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.
N407UTMed Trans Corp · Denton, TXN4088YDumont Associates · Morris Plains, NJN40DVNordstrom Eric Trustee · Anchorage, AKN40MCScotts Helicopter Service · Le Sueur, MNN410SCAlfheim II LLC · Menomonee Falls, WIN411DDHbh Aircraft LLC · Stratford, CTN411JHHeidrick Joe · Woodland, CAN411TDRotor Head Helicopters LLC · Torrance, CAN411WJNorthwest 60 LLC · Kalispell, MTN4155KPereira Alfred R Jr · Valley Springs, CAN415WCWilson Construction Co · Canby, ORN41AJEnglish Air Service LLC · Georgetown, TXN41EWMemphis Police Department · Memphis, TNN41PHTobler Hans P · Anchorage, AKN41WEEastward Aviation Inc · Eagle Lake, TXN420KTRegistered aircraftN420LECox Robert D · Girdwood, AKN420WPQualitair LLC Trustee · MichelstadtN421KY250 Logistics LLC · Mount Pleasant, TXN421SPKentucky State Police · Frankfort, KYN4237MTrideca Vertical Solutions LLC · Dallas, TXN425WCWilson Construction Co Inc · Canby, ORN4265JRatcliff Dustin · Saltville, VAN4292DUrocopters Inc · Lancaster, CAN42FFBeef Aviation LLC · Bradenton, FLN42LHFly Hangar 13 LLC · Mico, TXN42MCD & L Aeronautics LLC · Wilmington, DEN430AGMcmahon Helicopter Services Inc · Canton, MIN430JRAircraft Holding Solutions LLC Trustee · Newark, DEN430NYMcmahon Helicopter Services Inc · Canton, MIN430STHigh Performance Helicopters Corp · Crestline, CAN430VPAerotrust Services Corp Trustee · Wilmington, DEN43142Scotts Helicopter Services Inc · Le Sueur, MNN431CAChem-Air LLC · Shreveport, LAN431HFHeliflite Shares LLC · Newark, NJN4328Air Gov II LLC · Rome, NYN432RDAirdine LLC · San Francisco, CAN432TVSky Choppers LLC · Seneca, KSN434STSchweizer Rsg LLC · Fort Worth, TXN43HHJohnson Flying Service LLC · Exira, IAN43MAMinuteman Aviation Inc · Missoula, MTN4445HBell Textron Inc · Fort Worth, TXN444JBAir First LLC · Pembroke, NHN444TVScotts Helicopter Service Inc · Le Sueur, MNN445Wisk Aero LLC · Mountain View, CAN4452Bravo Aviation LLC · Chicago, ILN445SAvitek Inc · Plymouth, MIN448EAEdgefield Aviation LLC · Sandy, ORN449SS & L Farm And Ranch LLC · Georgetown, TXN44SZEnstrom Helicopter Corp · Menominee, MI
Back to AD 2005-10-13