AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N56996Zarn Douglas J · Amboy, MNN56997Bibb John G · Paragould, ARN56999Lofty Images LLC · Owosso, MIN5699DClear Lake Management Corp · Wilmington, DEN5699HHalmans John D · Baker, MTN5699NStyer David B · Pendleton, ORN5699ULrh Equipment LLC · Pendleton, ORN5699VMesmer Robert F · Grand Island, NYN569BSZanetta Wayne T · Portland, ORN569DPHale William J · Whitehouse, TXN569FLN7396w LLC · Coeymans Hollow, NYN569MKindred Daniel P · Jacksonville, ILFirst renewal noticeN569MTMiddle Tennessee State University · Murfreesboro, TNN569NEMcclung Aerial Spraying Inc · Big Springs, NEN569RVRicketts Michael D · Weirsdale, FLN569SPGlobal Flight Training Solutions Inc · Immokalee, FLN569TJAnderson Thomas C · Poplar Grove, ILN569TSBig South Fork Aero Inc · Huntsville, TNN569WHGp Cub Air LLC · Sioux Rapids, IAN56AMPeavy Michael J · Chico, CAN56BGGuernsey Gibson R · Belen, NMN56BVEuroaviation Inc Trustee · KematenN56CEWave Shack Acquisitions LLC · Lewes, DEN56CPBulldog Aviation LLC · Goodyear, AZN56DBBerger Dale · Bay Village, OHN56DDMeier Perry S · Conroe, TXN56DFThorpe Arthur N Jr · Salisbury, MDN56DGEagle East Aviation Inc · North Andover, MAN56DWReed John S · Wasilla, AKN56EB56 Eb Inc · Jacksonville, FLN56ECBpc Aviation LLC · Rosamond, CAN56EKQuailair LLC Trustee · MichelstadtN56EPSanders Flight Training Center Inc · Jasper, ALN56ERGsell Bruce Ward · Southampton, NJN56FAir Kings LLC · West Chester, PAN56FASilver Express Co DBA · Miami, FLN56FDDefibaugh Fred M · Chino Alley, AZN56FJRocky Mountain Construction LLC · Klamath Falls, ORN56FRWoods Mark T · Fernandina Beach, FLN56GBCalhoun Keith A · Springville, TNN56GH45g Aviation Services LLC · Fenton, MIN56GTDonaldson Timothy A · Oklahoma City, OKN56HCFaire Ken · Mojave Valley, AZN56HJRobinson Douglas J · Dayton, NVN56HRStrachan Annmarie C · Overgaard, AZN56HYCipolli Robert J · Montgomery, MAN56JFWadsworth Chad · Lake Havasu City, AZN56JSPoppy Wayne J · New London, WIFirst renewal noticeN56JUSurfield Ronald W · Leonardtown, MDN56KCCrawford William K · Ovilla, TX
Back to AD 90-04-06 R1