AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-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:2005-10-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:2005-10-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:2005-10-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.
N67882Mf Helicopters LLC · Troy, WIN67907Churchill Scott · Jordan, MNN67908Usda Aphis Ws · Cedar City, UTN67915Stovall Eric M · Marathon, TXN67919Ko Hee · Norwood, NJN67937Churchill Scott · Jordan, MNN67939City Of Jackson Tennessee · Jackson, TNN67950United States Army · Redstone Arsenal, ALN67952City Of Jackson Tennessee · Jackson, TNN67960Dakota Air Parts International Inc · Fargo, NDN67961Brown Helicopter Inc · Pensacola, FLN67968United States Army · Redstone Arsenal, ALN67978Mf Helicopters LLC · East Troy, WIN679AGUsda Aphis Wildlife Services · Cedar City, UTN67CLHelicopters Inc · Linden, NJN67FABas Part Sales LLC · Greeley, CON67HFPadgett Ag Rotors LLC · Missoula, MTN67LHTurn 7 Leasing LLC · Helena, MTN682BHBa Group LLC · Glastonbury, CTN685KWFive Kilo Whiskey LLC · Key West, FLN686AMAir Methods LLC · Greenwood Village, CON68LFLarsen Richard · Rexburg, IDN68PHMercury Aviation Inc · Flowood, MSN690PDBoard Of Police Commissioners · Kansas City, MON690WAWindward Aviation Inc · Puunene, HIN691PDBoard Of Police Commissioners · Kansas City, MON692PDBoard Of Police Commissioners · Kansas City, MON694ATSzucs Attlia · Port Orange, FLN695MCTom Cline Helicopter LLC · Lake Ozark, MON69875Gateway Youth Aeronautical Foundation · Maryland Heights, MON69DVTripwire South LLC · Gettysburg, PAN69FHelicopters Inc · Cahokia, ILN69GECbft LLC · Mobile, ALN69TPAirtime Marketing LLC · Middletown, DEN6BUAgricultural Air Services LLC · Jupiter, FLN6ENEnstrom Helicopter Corp · Menominee, MIN6MQR Consulting & Sales Inc · Carson City, NVN6QDSierra Golf Rotorcraft LLC · Wilmington, DEN6ULHelicopters Inc · Wilmington, DEN6YJetran LLC · Horseshoe Bay, TXN700FKBhh Leasing #4 LLC · Pensacola, FLN701HAHelo N701ha LLC · Richmond, VAN701KPKp Properties LLC · Auburn, WAN702BABlue Air Training Corp · Las Vegas, NVN702CG702cg LLC · Muskogee, OKN702SH702sh LLC · Kalispell, MTN70512Bank Of Utah Trustee · Salt Lake City, UTN705FSHvl Construction Inc · Fresno, CAN705KPOceans Alaska LLC · Dover, DEN705MPSmith Mark K DBA · Hubertus, WI
Back to AD 2005-10-13