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.
N9151THiller Aircraft Corp · Firebaugh, CAN9159FApex Heli-Support LLC · Phoenix, AZN91637Usda Aphis Ws · Cedar City, UTN916GSFlight International Inc Trustee · Dover, DEN91763Sterling Acres LLC · Santa Fe, NMN9177FRotor View Inc · Wilmington, DEN917SUSouthern Utah University · Cedar City, UTN9196FAsbill Jimmy T · Winnsboro, TXN919ACKw Air LLC · Darlington, INN91WSSunny Sky LLC · Stacyville, IAN920HAMshr Helicopter Service LLC · Chehalis, WAN920JPKar Aviation LLC · Saltville, VAN921SDCounty Of Fresno · Fresno, CAN922MCGeco Inc · Wilmington, DEN922SDCounty Of Fresno · Fresno, CAN9233FC & D Helicopters LLC · Spanish Fork, UTN9276FHeli-Flite Inc · Corona, CAN9290ZMaco Aviation Inc · Dayton, WAN935MAlan Aviation LLC · Los Angeles, CAN93BHBlue Hill Helicopters LLC · Norwood, MAN93CPKlump Aviation LLC · Bowie, AZN93LLHelicopters Inc · Linden, NJN93MDNew Horizons Helicopters Inc Trustee · Wilmington, DEN93MKDel Rio Aviation Inc · Paso Robles, CAN9460TEvermore Aviation LLC · Wasilla, AKN946MBemer Aviation Inc · Glastonbury, CTN94VMMachugh David · Pasco, WAN94XAXtreme Aviation LLC · Falkville, ALN952SDHeli Fly Inc Trustee · Wilmington, DEN952SFRegistration Pending · Elko, NVRegistration pendingN953AZRight Brother Aviation LLC · Chaffee, NYN954FBGreenery LLC · Wilmington, DEN954TJTx Investments LLC · Fort Lauderdale, FLN956KBIrie Leasing LLC · Trenton, NJN95LPPanther Helicopters Inc · Belle Chasse, LAN95SKCentral Virginia Aviation Inc · North Dinwiddie, VAN965RWWilmarth Russell · Alton Bay, NHN9677NDat Aircraft LLC · Lewes, DEN969RLRanger Aviation Leasing LLC · Wilmington, DEN969VSVertol Systems Co Inc · Destin, FLN96NWNorthwest Helicopters Inc · Olympia, WAN970YGCbk LLC · Eagle, CON9711ZRed Leasing LLC · Juneau, AKN971RHTurbines Ltd · West Point, NEN973RHTurbines Ltd · West Point, NEN975RHTurbines Ltd · West Point, NEN9762CFort Wolters Helicopters · Mineral Wells, TXN979RHTurbines Ltd · West Point, NEN97PHProvine Helicopter Service Inc · Greenwood, MSN97RRCounty Of Ocean · Barnegat, NJ
Back to AD 2005-10-13