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.
N21394Long Island Aviators LLC · Seaford, NYN2139BN2139b LLC · Newark, DEN2139JHotung Lisa M · Amherst, NYN2139KPolly P LLC · Fort Worth, TXN2139TFlight School Of Gwinnett Inc · Lawrenceville, GAN2139UJust Plane Stuff Inc · Jackson, MSN2139WRegistration Pending · Lake Worth, FLRegistration pendingN213ACRtb Transport LLC · Evans, GAN213BPJim Nichols Air Service LLC · Fincastle, VAN213CBSkymates Inc · Wilmington, DEN213CDJungman Frank · Escondido, CAN213CMBollingberg Kurt O · Cathay, NDN213CRJuarez Justin · Garden City, IDN213CSAeromarine Airways Inc · Miami, FLN213DSLexington Flying Club Inc · Lexington, KYN213GGShortcut LLC · Kihei, HIN213HTValdovinos Candido · Monroe, WAN213JMHagleitner Gunther · San Jose, CAN213LPT31 Aviation LLC · Dallas, TXN213MBNational Tax Relief Inc · Riverside, CAN213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN213PMainstream Aviation LLC · Benton, KYN213SALatrobe Aviation Enterprises LLC · Youngstown, PAN213SFSeaton Flying Services · Killeen, TXN213SMArrowhawk Imaging LLC · Morgantown, WVN213TJNewsome Timothy S · Alta Loma, CAN213WTCarmer Jacob D · Mount Morris, MIN21406Makushin Logistics LLC · Fairbanks, AKN2140RStidham Stephen A · North Pole, AKN2140TCupples Thomas Joseph · San Marcos, CAN2140VSidhu Harish · Anaheim, CAN2140WAbbott Bruce E · Seal Beach, CAN21411Piper Partners · Coventry, CTN21412Long Island Aviators LLC · Seaford, NYN21413Botwinick Jeffrey Richard Patrick · Syracuse, NYN21418Woodard Christopher Shane · Forney, TXN2141DFoturis Inc · Kingston, PAN2141JRegistered aircraftN2141RM5:16 Ventures LLC · Brush Prairie, WAN2141THorizon Ventures Inc · Red Oak, IAN2141WMeyer Carl F Jr · Eagan, MNN2141YAnson Air LLC · Sugar Land, TXN21425Nelson Phillip · Jonesboro, ARN2142RFieldhouse Warren W · Ocala, FLN2142SDbm Farms Inc · Clarksdale, MSN2142XAnvab Inc DBA · Concord, NHN2142YChanfrau Frederic · Barrington, RIN21435Car Guys Aviation LLC · Lead, SDN21436Smith Michael W · Bracey, VAN21438Texas State Technical College · Waco, TX
Back to AD 2006-10-21