AD 2000-22-03
Registered aircraft · 425
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:2000-22-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-03')
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:2000-22-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-03') 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.
N212AGSea Aviation Holdings LLC · Wilmington, DEN212XXLegacy Aviation Trust Holdings Corp · Edmond, OKN213RGGlobal Avionics LLC · Downey, CAN214TDHarbor Aircraft LLC · Wilmington, DEN218PJSoany Steam Inc · Cheyenne, WYN218RXAviation Resource Group Inc · Fort Lauderdale, FLN220JJCsc Delaware Trust Co Trustee · Wilmington, DEN220PFExecutive Air Taxi Corp · Bismarck, NDN222PBBlanchard Aviation LLC · Albuquerque, NMN224JL205 Flintstones LLC · Flint, MIN22CPRegistered aircraftN230TSDodson International Parts Inc · Rantoul, KSN23CJGrzechowiak Gary L · Denison, TXN2409KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN240VN240v LLC · Wilmington, DEN241JSE D Santos & Associates LLC Trustee · Wilmington, DEN244FLAviation Leasing Group Inc · Wilmington, DEN248ECEc Aviation LLC · Lake Oswego, ORN24SMExecutive Air Solutions Corp · Fort Lauderdale, FLN250MBNo Layover LLC · Hays, KSN254SBHawker 800xp LLC · Fort Lauderdale, FLN257PLTavaero Jet Charter Corp · Houston, TXN258MRE D Santos & Associates LLC Trustee · Wilmington, DEN259RHAlliance Aviation Group LLC · Wilmington, DEN25XPRd Airways LLC · Channelview, TXN261PACalla Airways LLC · Cohasset, MAN263SNBlue Skies Hawker LLC · Whitefish, MTN265JGShell Mountain Ranch LLC · Cranfills Gap, TXN26MEJ Jets Inc · Los Angeles, CAN26TCAcme Nite LLC · Nashville, TNN2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN277RSMaize & White Aviation LLC · Youngstown, OHN2787Valiair Lc Trustee · Casper, WYN279CFJ Jets Inc · Dover, DEN285RAAsesu Aircraft LLC · Miami, FLN285XPAviation Fjaf LLC · Davie, FLN28ZFCore Projects Inc · Fresno, CAN298WB45 Srl Inc · Houston, TXN3007Empire Airlines Inc · Lebanon, MON300CQHawker 4 LLC · Jensen Beach, FLN304BHCalla Airwaysllc · Cohasset, MAN307XPSkybridge Aviation Group Inc · Apopka, FLN308DD225sbi LLC · Stuart, FLN310EJZenodro At Tranquility Aviation LLC · Clermont, FLN311FLAlliance Aviation Group LLC · Wilmington, DEN312FUKenmore Crew Leasing Inc Trustee · Bellingham, WAN312STexas Aircraft Parts Brokers LLC · Seguin, TXN314TCTop Cat Aviation LLC · Pelham, ALN315RCRocklyn National LLC · Syracuse, NYN316MFMf Property Management LLC · Hattiesburg, MS
Back to AD 2000-22-03