AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1176ZAirborne Support Inc · Bourg, LAN11771Boss Gary W · Bronston, KYN1177AN1177a LLC · Lewes, DEN1177BTakacs John Paul III · Colorado Springs, CON1177XParrish View Farms · Kenbridge, VAN1178COliveira Frank Jr · Pawtucket, RIN1178XN1178x LLC · Dover, DEN11799Borba Steven D · Woodland, CAN1179XDesch Edward J III · Aldie, VAN117BAChopper Ag Services LLC · Samson, ALN117BCGiardina Edward Charles Jr · Cranston, RIN117BMManeck Aviation LLC · Columbus, GAN117CGGould Cedric O · Tehachapi, CAN117CLIcenogle Roger A · Inver Grove, MNN117CSSam Airlines LLC · Wilmington, DEN117DHans Wolfgang Grotendiek Lc · Dorr, MIN117DBHawley Vance L · Idaho Falls, IDN117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKN117HREmax LLC · Perry, GAN117HWYale Companies LLC DBA · Fishers, INN117JASorbi Aviation Inc · El Cajon, CAN117JCHillsboro Flying Club · Hillsboro, ORN117JRFaith Christopher D · Columbus, MSN117KRFox Planes LLC · Sterling Heights, MIN117LGreene Mangos LLC · Anchorage, AKN117LWBlasdel Michael J · Fort Worth, TXN117MCParish Of East Baton Rouge · Baton Rouge, LAN117MJPhillabaum Jack O · Midland, GAN117MMMelton Charlie W · Grand Saline, TXN117PBLadue Scott B · Fate, TXN117QPacourek John R · Casco, WIN117RGInternational Air Services Inc Trustee · Carson City, NVN117RJFine Frank E · Oakdale, CAN117RWAli Mohammad Usman · Fort Worth, TXN117SEHalsell Jason · Wolfforth, TXN117SVFlight Operations Aircraft LLC · Wilmington, DEN117TAMares Thomas · Gloucester, VAN117TDGiffin Craig D · Windermere, FLN117TKWindstar Air LLC · Carroll, IAN117TMRegistered aircraftN117TRCrabtree Andrew J · Ottawa, KSN117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CAN117WVRedline Onsite Services LLC · Opelousas, LAN11802N11802 LLC · Bradenton, FLN1180JVegas Alex · Leesburg, VAN1180NWinkelmann Aerospace LLC · Malabar, FLN1180XK & K Aero Inc · Wilmington, DEN1181ECalifornia Antique Aircraft Museum · San Martin, CAN1181JWinston James Eldon Jr · Granbury, TXN11823Redbird LLC · Denver, CO
Back to AD 2006-10-21