AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N4453QKeene Greggory L · Abbeville, GAN4453RJackson Robin D · Harlan, IAN4453ZBoyer Skip P · Oak Harbor, WAN44542Waldraff Hans C · Delafield, WIN44543Evers Jeffrey P · Export, PAN44546Polka Todd M · New Philadelphia, OHN4454AMcclanahan Luke D · Decherd, TNFirst renewal noticeN4454JEvans Craig · Bastrop, LAN4454RDekle Drew · Athens, GAN4454ZWilliams Kenneth J · Wasilla, AKN4455Sanders Russell · Canton, GAN44553Murrell Stanley D · Alabaster, ALN44555Miloud Chadd K · Fort Worth, TXN44556Sayonara Air LLC · Old Hickory, TNN44558Yoder Jonathan · Farmington, MON4455BBriggs Robert B · Germantown, TNN4455MClear Prop LLC · Roswell, GAN4455QHaring Clay DBA · Lincoln, KSN4455SFlying Adventures LLC · Uniondale, NYN4455TK-T Customs LLC · Mustang, OKN4455VHorsefly Aviation LLC · Helena, MTN4455XHarding Candace B · Livermore, CAN4455ZWindsor Greg A · Anchorage, AKN44560Niewenhuis Larry D · Grand Ledge, MIN44566Skybound Aviation LLC · Kernersville, NCN4456RTruskey David R · Dauphin, PAN4456SFressh Air LLC · Vancouver, WAN4456WMetal Finishing Co Inc · Wichita, KSN4456XFly By Knight Corp · Shoreview, MNN4456ZHayton James B · Sedro Woolley, WAN44571Boas Mark S · Hollywood, MDN44572Hornet Aviation Inc · Tallahassee, FLN44575Fit Overflow LLC · Davidson, NCN44579Schaible Peter J · Springfield, VAN4457BCelestina Harold C · Ester, AKN4457PSkyhaven Airport Inc · Tunkhannock, PAN4457SRegistered aircraftN4457ZK Ranches Aviation · Bozeman, MTN44580Mtt Aviation Services Inc · Johnstown, PAN44583Griffin Avionics Inc · Hyannis, MAN44584Boomerang Air LLC · Cedar Park, TXN44586Ts Construction General Contractors Inc · Yates Center, KSN44588N44588 LLC · Vero Beach, FLN4458ARaimondi Johann I · Doral, FLN4458JMillan Sanchez Omar · Sussex, NJN4458SCn Aviation LLC · Mesa, AZN4458ZAerial Crop Care Co · Hebron, NDN44590Lee John Michael · Van Nuys, CAN44592Registration Pending · Venice, FLRegistration pendingN44593Mcgaughey Kevin B · Milan, TN
Back to AD 2007-04-19 R1