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.
N317CQPrivate 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, TXN338SWN338sw LLC · Midland, TXN339AVKmwflight LLC · Wilmington, DEN33BCSworks Aviation LLC · Chicago, ILN33RCBank Of Utah Trustee · Salt Lake City, UTN343SCMtj Aviation LLC · Mooresville, NCN348AJE E & K C LLC · New Orleans, LAN353JABasler Turbo Conversions LLC · Oshkosh, WIN355FAE D Santos & & Associates LLC Trustee · Wilmington, DEN356EJAlliance Aviation Group LLC · Wilmington, DEN356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLN361CAN361ca LLC · Wilmington, DEN361LABest Friends Air LLC · Kerrville, TXN369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN375PFConch Air LLC · Green Bay, WIN375RC2022 Olivia Av LLC · Austin, TXN383MVN383mv LLC · Amarillo, TXN383TKThk Holdings LLC · Cincinnati, OHN384ABArkoma Air LLC · Rockwall, TXN389SRIgnite Enterprises LLC · Cerritos, CAN391BVcs Encore LLC · Austin, TXN39QJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN406TMAlcyone Trust Corp Trustee · Wichita, KSN411SCRegistered aircraftN412DAVida Trade And Management Group LLC · Charlotte, NCN412JADodson International Parts Inc · Rantoul, KSN413HSAerotrust Services Corp Trustee · Wilmington, DEN414PEAerotrust Services Corp Trustee · Wilmington, DEN417TMCpj2 LLC · Garden City, NYN418CASkybus Inc · North Miami Beach, FLN422CSBusiness Jet Managers Inc · Canton, MIN423SGSworks Aviation LLC · Chicago, ILN42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN432SMWorldwide Option LLC · Lewes, DEN4343FFrenkel Tardis Development Corp LLC · Dallas, TXN43JRGlobal Avionics LLC · Downey, CAN43MMAircraft Holding Solutions LLC · Newark, DEN43TPAircraft Holding Solutions LLC Trustee · Newark, DEN440WPBbft Aero Holdings LLC · Columbus, OHN442MSWd Aviation Group Inc · Atlanta, GAN444JFBod Aviation LLC · Los Angeles, CA
Back to AD 2000-22-03