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.
N3028HRegistered aircraftN3028MLittle Robert · Ocala, FLN3028QAllenspach Timothy L · Stillwater, MNN3028WK2 Aviation LLC · Carroll, IAN3028YStanton Tod J · Naperville, ILN3028ZDavis Robert L · Wasilla, AKN30293Advantage Aviation Services LLC · South Saint Paul, MNN30297Siers Richard · Ocean Shores, WAN3029CHeyneman John M · Sheridan, WYN3029HSmith Zachary · Nokesville, VAN3029MBaumgartner Rhone J · Mc Grath, AKN3029QOzarks Auto Show Inc · Hollister, MON3029ZSuper 20 LLC · Brandon, SDN302AFState Of Louisiana · Baton Rouge, LAN302AMHughes Jason · Visalia, CAN302AVRas Aviation LLC · Elyria, OHN302BCG2 Leasing LLC · Cedar Spring, MIN302BYAviation Homes LLC · Terrell, TXN302CDChadmatt Explorations LLC · Pensacola, FLN302CFEastern Kentucky University · Richmond, KYN302CMMurray Craig W · Raymond, WAN302CWWarrington James Whittaker O Jr · Lexington Park, MDN302DBHouston Chet H · Beaufort, SCN302DSMt Zephyr Enterprises LLC · Yorktown, VAN302EFRedbird Ventures LLC · Kalispell, MTN302FGTactical Aviation LLC · Plymouth, MIN302GAtp Aircraft 9 LLC · Wilmington, DEN302GPInternational Air Services Inc Trustee · Carson City, NVN302JAAviate LLC · Green Bay, WIN302JBS C Flying Service Inc · Ravenden Springs, ARN302JHYang LLC · Lewisburg, WVN302KTSkydrift Aviation LLC · Kalispell, MTN302MAHopler Harold W · Helena, MTN302MCB & G Ventures LLC · Kalispell, MTN302MGGeorgia Aviation Authority · Eastman, GAN302MPKqm Aviation · Bristow, VAN302MXGove Gary Alan Jr · Marion, MTN302NLRussell Grant R · Roxbury, CTN302PASkywest Leasing Inc · St George, UTN302RMHillger Michael D · Garden City, TXN302SKHaynes Daniel R · New Braunfels, TXN302STManagement Support Services LLC · Naturita, CON302TXCareer Track 2 LLC · Wilmington, DEN302USolomon Mark Trustee · Wilmington, DEN302WDivine John S III DBA · Myrtle Beach, SCN302ZSutherland Derrick L · Ada, OKN30301Brown Gregory R · Spotsylvania, VAN30302Kamenar Service LLC · Mukwonago, WIN30304Williams Rod · Atascadero, CAN30307Johnston Phillip Jr · Pensacola, FL
Back to AD 2007-04-19 R1