AD 2000-16-05
Registered aircraft · 428
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-16-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:2000-16-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:2000-16-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:2000-16-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.
N653CHKelley Aviation Consultants LLC · S Williamsport, PAN656RBBas Part Sales LLC · Greeley, CON662RSBender Jeff L · Canal Winchester, OHN67TKBuckley Michael J · Billings, MTN691RRAnderson Stuart R Jr · Sahuarita, AZN699LCAero Management LLC · Austin, TXN7032ZJones James William III · Lebanon, VAN7050DFoster David S · Justin, TXN7057LTri County Rentals And Sales Inc · Chiefland, FLN705RMReynolds Darryl G · Wills Point, TXN711CHYoung Vernon P · Metter, GAN71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN721CBLung Brian · Williamsburg, OHN721SPSchweizer Rsg LLC · Fort Worth, TXN7233USuttle Joseph S · Moody, ALN725AN725a LLC · Manassas, VAN72LPRavens Rebuilders Inc · Ellenboro, WVN72LTReynolds Cindy L · Wills Point, TXN731TATomlinson Aviation Inc · Ormond Beach, FLN7364HReam Aviation LLC · York, PAN7419FSmith Helicopters Inc · Cotulla, TXN7446FAir Sprayers Inc · Two Buttes, CON7452FReep Nic K · Yakima, WAN7463FWendling Mark A · Bryant, SDN7465FSmith Norman L · Houston, TXN7482FSchweizer Rsg LLC · Fort Worth, TXN7489FColdwell Jerry Lee · Jordan, MTN7490FDodson International Parts Inc · Rantoul, KSN7492FHouston Police Dept · Houston, TXN7493FHouston Police Dept · Houston, TXN74LTDevor Aviation Support Services LLC · Chambersburg, PAN7504SAirczar LLC DBA · Corpus Christi, TXN7504ZMid Pacific Aero Services LLC · Honolulu, HIN7505BSilver Wings Inc Trustee · Wilmington, DEN75068Kinzie Industries Inc · Erie, COExpired dealerN7506NMeshoppen Air LLC · Tunkhannock, PAN75070Mansfield Heliflight Inc · Milton, VTN7507CBlair & Son Inc · Fleetwood, PAN7507MWeststar Ventures LLC · Cannon Falls, MNN7507USierra Sky Aviation LLC · Kalispell, MTN7508HSons Aviation LLC · Moody, ALN7508LBruegger Shannon B · Lance Creek, WYN75105Mitchell Maverick LLC · Mitchell, SDN7511ACouch Construction Co LLC · Palestine, TXN767LHJones Aircraft Co LLC · Cross Plains, TNN771AAJones Aircraft Co LLC · Cross Plains, TNN776LHJones Aircraft Company LLC · Cross Plains, TNN789LHJones Aircraft Company LLC · Cross Plains, TNN801CPMoore Bradley J · Logsden, ORN801SLZadow Ryszard Jerzy · Waller, TX
Back to AD 2000-16-05