AD 2017-18-14
Registered aircraft · 1,632
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:2017-18-14')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-18-14')
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:2017-18-14') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-18-14') 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.
N109PBBennedsen Rosa Fadia Gabriel · Aventura, FLN109RASunny Sky LLC · Stacyville, IAN109USU S Helicopters Inc · Marshville, NCN109WGDodson 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, CAN10LKHelius Aircraft Service LLC · Conroe, TXN10MSKas Enterprises LLC · Lewes, DEN10MWJk Aviation LLC · Grosse Ile, MIN10MYBoston 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, GAN111JDAlbert Hall Co LLC · Port Angeles, WAN111PMTri Rotor Spray And Chemical · Ulysses, KSN1128SAerial Organics LLC · Wilmington, DEN112LPRanger Aviation Leasing LLC · Wilmington, DEN113RLMarks Aviation Group LLC · Lafayette, LAN113WCRebel One LLC · Dover, DEN114AFNe Ia Helicopter LLC · Tekamah, NEN114GSAviation 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, DEN117HKSettan 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, ILN11SRM3p Interests LLC · Missoula, MTN11ZGWhite Star Marine Services LLC · Basalt, COFirst renewal noticeN11ZXBig Bird Leasing Inc · Saint Peter, MNN1201WMagnum Aviation LLC · Goff, KSN120LHHelilease LLC · Lewes, DEN1219WMoes Crop Dusting Service Inc · Marysville, CAN122BTNorth Wind Aviation LLC · Cottage Grove, ORN122JLotus Aviation LLC · Boring, ORN123NMAglk LLC · Lewes, DE
Back to AD 2017-18-14