AD 2016-20-06
Registered aircraft · 453
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:2016-20-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-06')
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:2016-20-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-06') 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.
N163MDArad Energy LLC · Conroe, TXN163PAN163pa LLC · Wilmington, DEN164PAPhoenix Air Group Inc · Cartersville, GAN165PARca LLC · Wilmington, DEN16GJGlobal Empire Trust LLC · Dover, DEN16JNSonance Rocket LLC · San Clemente, CAN171JCAlliance Aviation Group LLC · Wilmington, DEN173PAN173pa LLC · Wilmington, DEN175BGMile High Holdings LLC · Miami, FLN176MGFlying Orchard LLC · Missoula, MTN177BBSbg Aircraft Sales And Consulting LLC · Missouri City, TXN178BMissile Defense Agency (Mda) · Tulsa, OKN178PTPlatinum Aviation LLC · Carson City, NVN17KWWcs Inc · Troy, ALN17LKAircraft Holding Solutions LLC Trustee · Newark, DEN180CHPointbank · Pilot Point, TXN181PRCgf 1280 LLC · Wilmington, DEN181US181us LLC · Boca Raton, FLN183PASandy Wings LLC · Wilmington, DEN184PABartowjets LLC · Wilmington, DEN188SAAlliance Aviation Group LLC · Wilmington, DEN18TVJax G Enterprises LLC · Scottsdale, AZN190PASandy Wings LLC · Wilmington, DEN192JERegistered aircraftN195PASandy Wings LLC · Wilmington, DEN196PASandy Wings LLC · Wilmington, DEN1979LCabana Air LLC · Frederick, MDN197BDAfc Management LLC · Englewood, NJN198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN198PABartowjets LLC · Wilmington, DEN1BGGlobal Empire Trust LLC · Dover, DEN1DWac I LLC · Fort Lauderdale, FLN1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1TDThreshold Ventures Inc · Scottsdale, AZN1TMMarsico Aviation LLC · Denver, CON2000Global Avionics LLC · Downey, CAN200LCSn 1067 LLC · Wilmington, DEN202PXZ & L Consulting LLC · Midland, TXN2107ZAir Prestigio LLC · Aliso Viejo, CAN211DHHagadone Aviation LLC · Coeur D Alene, IDN213EFMontana Aircraft Trust Inc Trustee · Bozeman, MTN218EESolomon Mark Trustee · Wilmington, DEN218KDMojave Jet LLC · Wilmington, DEN218MDNe-2 LLC · Houston, TXN220TDRegistration Pending · Rantoul, KSRegistration pendingN221EAGlobal Acquisition Holdings LLC · Oklahoma City, OKN221MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN222GYSpec Air LLC · Miami, FLN222NPAircraft Fidelity Corp Trustee · Dover, DEN225DCAvion LLC · Birmingham, AL
Back to AD 2016-20-06