AD 2001-24-12
Registered aircraft · 1,292
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:2001-24-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-24-12')
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:2001-24-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-24-12') 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.
N109WGDodson International Parts Inc · Rantoul, KSN109WJL S Service Corp · Wilmington, DEN109XPNational Test Pilot School · Mojave, CAN109ZTValiair Lc Trustee · Casper, WYN10AJEl Aero Services LLC · Elko, NVN10BKRiley Jake · New York, NYN10JSSiegel Jerry S · Los Angeles, CAN10KXWhirly Leasing Inc · Richvale, CAN10MSKas Enterprises LLC · Lewes, DEN10MYBoston Executive Helicopters LLC · Norwood, MAN1102DAviation Advantage Inc · Tabor City, NCN1103LAviation Advantage Inc · Tabor City, NCN11056Northwest Helicopters I Inc · Olympia, WAN110GLQualitair LLC Trustee · MichelstadtN110WGMeshoppen Air LLC · Tunkhannock, PAN111ADSvp LLC · Missoula, MTN111HFPlane Fun Inc Tr Trustee · Snellville, GAN111PMTri Rotor Spray And Chemical · Ulysses, KSN1128SAerial Organics LLC · Wilmington, DEN112LPRanger Aviation Leasing LLC · Wilmington, DEN113RLMarks Aviation Group LLC · Lafayette, LAN114GSAviation Company Inc · Cheyenne, WYN114HDWindward Aviation Inc · Puunene, HIN1158BAir Gov 1 LLC · Rome, NYN115ECSara Helicopters Inc · Wilmington, DEN115HDLaroche Aviation Services LLC · Bellaire, OHN115SUSignature Property Holdings LLC · Wilmington, DEN116MVWing And Rotor Transportation Holdings LLC · Morristown, NJN117HKSettan Corp · Goleta, CAN118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN118TVInterstate Helicopter Inc · Bethany, OKN119TTaylor Robert T · Chehalis, WAN11CQScotts Helicopter Service Inc · Le Sueur, MNN11FHD H Helicopter Inc DBA · Sauget, ILN11ZXBig Bird Leasing Inc · Saint Peter, MNN1201WMagnum Aviation LLC · Goff, KSN120LHHelilease LLC · Lewes, DEN1211MArchangelair LLC · Wilmington, DEN1219WMoes Crop Dusting Service Inc · Marysville, CAN122BTNorth Wind Aviation LLC · Cottage Grove, ORN122JLotus Aviation LLC · Boring, ORN123MGHagedorn Aviation Inc · Columbus, OHN123NMAglk LLC · Lewes, DEN124EHJbp Aviation LLC · Henderson, NVN124PDH & O Helicopters Inc Trustee · Wilmington, DEN125KWAurora Aviation Services Inc · Delta Junction, AKN126KWHlh Leasing LLC · Wilmington, DEN127APGm Leasing Co LLC · Broussard, LAN128EEAlgab Holdings LLC · Newark, DEN128GCCga Holdings LLC · Kalispell, MT
Back to AD 2001-24-12