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.
N2391GSeay Bradley Andrew · Vienna, VAN2391MClover Park Technical College · Lakewood, WAN2391QNew Hamphire Flyers LLC · Lyme, NHN2391UJeffway Robert W Jr · Leeds, MAN2392BMorton Dennis D · La Harpe, ILN2392QTwin Eagle Flying Club Inc · Pikeville, KYN2393ZSky Training LLC · West Milford, NJN2394Logan Jason W · Columbia, PAN2394MOld Buzzard Ltd · Columbus, OHN23959State Of Wisconsin · Madison, WIN2395TSingh Harsimran · Las Vegas, NVN2395VConfluence Systems Consulting Inc · San Jose, CAN23966Misbe Darrell James · Pierz, MNN2396SLebeouf Bros Towing LLC · Houma, LAN2396XZadow Ryszard J · Waller, TXN23976Brazdys Luke V · Kingman, AZN23979Grounds Cameron · Sachse, TXN2397EMaine Instrument Flight · Augusta, MEN23986Mcintyre Joel · Greensboro, NCN2399TThompson Nolan E · Houston, TXN2399UChilhowee Soaring Association Inc · Benton, TNN2399WHudson Shayne · Victorville, CAN239AShiloh Flite Five · Eden, NCN239ATAirline Transport Professionals Corp Of USA · Wilmington, DEN239CWolvestown LLC · Humble, TXN239DJDj Wings Holding LLC · Greenlawn, NYN239FGRidgeline Assets LLC · Wilmington, DEN239GHicks Gregory · Florence, ORN239JAHot Wings Aviation LLC · Indianapolis, INN239KStick Ball Rudder LLC · Bonita Springs, FLN239MAHeath Robert D · Locust Grove, GAN239MGGeorgia Aviation Authority · Eastman, GAN239PD&J Training Planes LLC · Logan, UTN239SPAvolant Aviation LLC · Mooresville, NCN239SWPyles William J · Pismo Beach, CAN23AKAction Air Inc · Wilmington, DEN23ALPv Aviation LLC · Poland, OHN23ASRusso James F · Liberty, SCN23AUAverett University · Danville, VAN23AVJtz Aviation LLC · Wilmington, DEN23BDCox Mike Trustee · Casper, WYN23BMAxiom Development And Consulting LLC · Atlanta, GAN23BQCentral Airlines Inc · Overland Park, KSN23CSWhitman Bruce R · Lowell, MIN23DBSky High Farmers LLC · Lakeville, MNN23DDK Tahoe Air LLC · Glendale, CAN23DYJenkins Douglas W · Universal City, TXN23EDMcdonough Roberto · Chino, CAN23EFRapid Flyers LLC · Zionsville, INN23EJIglesias Constance · Waller, TX
Back to AD 2006-10-21