AD 96-09-13
Registered aircraft · 772
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:96-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-09-13')
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:96-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-09-13') 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.
N218DZRed Brick Summit LLC · Wilmington, DEN218GJJaztec LLC · Ooltewah, TNN218SLAlpine Aviation Inc · Provo, UTN219RMMoro Aircraft Leasing Inc · Two Rivers, AKN219VPAlpine Aviation Inc · Provo, UTN21BDSouthern Illinois Helicopters LLC · Marion, ILN21CGN21cg Leasing LLC · Ponca City, OKN21FWUas Transervices Inc · Boca Raton, FLN21RZUas Transervices Inc · Boca Raton, FLN220GLAlpine Aviation Inc · Provo, UTN220KWAirselect LLC · West Point, IAN220RARoyal Air Freight Inc · Waterford, MIN220VTExec III LLC · Maineville, OHN221BHUas Transervices Inc · Boca Raton, FLN222CYBlue Star Gas Fleet Services Co · Santa Rosa, CAN223BHUas Transervices Inc · Boca Raton, FLN223CABemidji Aviation Services Inc · Bemidji, MNN223MWWhiskey Tango LLC · Midland, TXN223TPAviapa LLC · Doylestown, PAN225BHUas Transervices Inc · Boca Raton, FLN226BHUas Transervices Inc · Boca Raton, FLN227AVUas Transervices Inc · Boca Raton, FLN22889Tenax Aviation LLC · Ridgeland, MSN228BHUas Transervices Inc · Boca Raton, FLN228RCPuro Humo Aviation LLC · Miami, FLN22FMjsmm LLC · Santa Rosa Beach, FLN22GSGbs Aviation LLC · Fort Worth, TXN22PEAdamb200 Holdings LLC · Broken Bow, OKN230BHUas Transervices Inc · Boca Raton, FLN231YVAlpine Aviation Inc · Provo, UTN234KW405 Transportation Partners LLC · Edmond, OKN235LCRosado Aviation Inc · Moosic, PAN236ALAlpine Aviation Inc · Provo, UTN237KConquest Express LLC · Libertyville, ILN237SLAlpine Aviation Inc · Provo, UTN238ALAlpine Aviation Inc · Provo, UTN239ALAlpine Aviation Inc · Provo, UTN239JVRim Group LLC · Waterford, MIN23WSDovey Air Inc · Birmingham, MIN240GLAlpine Aviation Inc · Provo, UTN241AXTailwind Investments LLC · Anchorage, AKN241PHPhi Health LLC · Tempe, AZN242AXTailwind Investments LLC · Anchorage, AKN242ZAN667kt LLC · Lewes, DEN243AMAirmed International LLC · Birmingham, ALN243CKKalitta Air LLC · Ypsilanti, MIN244AXTailwind Investments LLC · Anchorage, AKN245AXTailwind Investments LLC · Anchorage, AKN245GLAlpine Aviation Inc · Provo, UTN246AAAir Services International Leasing LLC · Fort Lauderdale, FL
Back to AD 96-09-13