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.
N4083A4083a LLC · Wilmington, DEN4083DAerohawk Aviation Inc · Idaho Falls, IDN4083EHulsey Steven M · Chugiak, AKN4083XKnutson Wayne R · Thompson, NDN4083ZRaymond Raphael T · Helix, ORN4084Dailey Garrett C · Alamo, CAN40842Avz Aviation Inc · Knoxville, TNN40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJN4084EIngham Ben B · Sonora, TXN4084SDavenport Michael · Naperville, ILN4084TEmerald City Aircraft Leasing Inc · Port Orchard, WAN4084WGraham Jessami T · Walsh, CON4084ZHull Keath C · Wasilla, AKFirst renewal noticeN40850Mitchell Timothy · Enterprise, ALN40852Air Performance LLC · Kalispell, MTN40855Covey Stephen B · Manvel, TXN40856Griggs Gerald A · Blairsville, GAN40857Muller-Levan Christina J · Kempton, PAN40858Dicey Aviation LLC · Somerset, KYN4085BMarroquin Jesse B DBA · Schertz, TXFirst renewal noticeN4085EGrass Roots Flying Inc Trustee · Wilmington, DEN4085PTango Bravo Aviation LLC · Taylorsville, MSN4085WIrvin Gary Z · Parrish, FLFirst renewal noticeN40862Ratliff William Thomas III · Knoxville, TNN4086APippert James R · Dysart, IAN4086DThompson George M · Fairbanks, AKN4086S80'S Associates Inc · Pittstown, NJN40872Ole South Aviators LLC · Athens, GAN40874Jones Sherman Farrell · Buena Park, CAN40876Gray John W · Rohnert Park, CAN4087PPankratz Laura M · Stroudsburg, PAN4087ZNcsb LLC · Anchorage, AKN40881Hsu Feng · Albuquerque, NMN40882Flight Factory LLC · Danville, CAN4088DIron Horse Aviation LLC · Omak, WAN4088FCole Warren G · Watkinsville, GAN4088MRam Aviation LLC · Palmer, AKN4088PBas Part Sales LLC · Greeley, CON4089Indrebo Rick J · Livermore, CAN4089DGaffney Justin L · Arcata, CAN4089FKorb Orry P · Santa Cruz, CAN4089SRaii3 LLC · Lewes, DEN408BWKough David M · Nashville, TNN408CACoast Flight Training And Management Inc · Dallas, TXN408CDKc Jet Sales LLC · Scottsdale, AZN408CLExecutive Helicopter Tours Inc · Saint Petersburg, FLN408CVCivil Air Patrol · Maxwell Afb, ALN408EAMagnell Gregory P Trustee · Vicksburg, MIN408EPAb Prop Plane II LLC · Metairie, LAN408FHStevens William C · Ashland, MT
Back to AD 2007-04-19 R1