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.
N44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLN450NANational Aerotech Aviation Delaware · Wilmington, DEN453LCIron Aviation LLC · Bozeman, MTN454DCEllis Dd King Air LLC · Midlothian, TXN454TMKardecas Corp · Houston, TXN456ESTripp Aviation LLC · Pearland, TXN466MW1977 Holdings LLC · Visalia, CAN468SPPacific Mission Aviation · Hagatna, GUN469SLAngely Air LLC · Lewes, DEN46CECentury Equipment Company Inc · Salt Lake City, UTN470MMSfc Global Supply Chain Inc · Marshall, MNN474LCAlpine Aviation Inc · Provo, UTN479BRGunner Aviation LLC · Fayetteville, ARN479VATactical Aviation Inc · Wilmington, DEN480BRFive Diamond Aviation Holdings LLC · Draper, UTN481HCIntermountain Medical Transport LLC · Salt Lake City, UTN486ATMeo Holdings LLC · Newark, DEN487NNDakota Equipment LLC · Bismarck, NDN487VCOaklr LLC · New York, NYN48CSMattias Transport LLC · Tucson, AZN48PACbc Aviation LLC · Hayden, IDN48QDynamic Avlease Inc · Bridgewater, VAN4925TAir Services LLC · Spokane, WAN492GPBank Of Utah Trustee · Salt Lake City, UTN499CZN499cz LLC · Milwaukee, WIN49UCUas Transervices Inc · Boca Raton, FLN4QLFremont Motor Company Inc · Lander, WYN500FEBeech Transportation Inc · Eden Prairie, MNN500HGEm Aviation Ka B200 LLC · Atlanta, GAN500LPMeri Acquisitions LLC · Kilgore, TXN503AWCsi Aviation Inc · Albuquerque, NMN504GFOxford Advisory Aviation LLC · Orlando, FLN505AWCsi 135 Division LLC · Albuquerque, NMN505SPN505sp LLC · Ontario, CAN507GFBallard Aviation Inc · Newton, KSN5092SGreat Plains Communications LLC · Blair, NEN509FPPerdue Farms Inc · Salisbury, MDN50GGN50gg Leasing LLC · Ponca City, OKN50KGTurbo Air Charter LLC · Boise, IDN50NABv Transportation LLC · Portland, ORN50PACenterline Aviation Inc · Middletown, DEN50XDynamic Avlease Inc · Bridgewater, VAN510GSAmdel Holding LLC · Houston, TXN511GAGeaux Aire LLC · Savannah, GAN511TAAir Med Services LLC · Lafayette, LAN514TBFast Marketing Strategies LLC · Royal Oak, MDN51RPUas Transervices Inc · Boca Raton, FLN520DGDanzer Veneer Americas Inc · Darlington, PAN522TGSe Express LLC · South Lyon, MIN524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 96-09-13