AD 2001-13-05
Registered aircraft · 398
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:2001-13-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-13-05')
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:2001-13-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-13-05') 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.
N220JJCsc Delaware Trust Co Trustee · Wilmington, DEN220PFExecutive Air Taxi Corp · Bismarck, NDN222PBBlanchard Aviation LLC · Albuquerque, NMN224JL205 Flintstones LLC · Flint, MIN22CPRegistered aircraftN2409KTvpx 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, TXN26TCAcme Nite LLC · Nashville, TNN2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN277RSMaize & White Aviation LLC · Youngstown, OHN279CFJ 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, MSN317CQPrivate Fliers LLC · Wheaton, ILN31ZZE D Santos & Associates LLC Trustee · Wilmington, DEN320EJAlliance Aviation Group LLC · Wilmington, DEN321MSTaughannock Aviation Corp · Ithaca, NYN323AAE D Santos & Associates LLC Trustee · Wilmington, DEN32KBS S K Hawker Group LLC · New Haven, CTN32PJRegistered aircraftN-number assigned (import), not yet registeredN333PCSemanik Investment Corp · Jacksonville, FLN333RLJetstream Air LLC · Colfax, NCN337WRAer Sales Lp · Carrollton, TX
Back to AD 2001-13-05