AD 2018-13-01
Registered aircraft · 1,802
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:2018-13-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-13-01')
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:2018-13-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-13-01') 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.
N109GLA Air Club LLC · Tampa, FLN109LBVertol Systems Company Inc · Destin, FLN109MMAirborne Leasing Inc · Sylmar, CAN109NLIntegrity Aircraft Title Holdings LLC · Portland, ORN109PBBennedsen 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, CAN10MSKas Enterprises LLC · Lewes, DEN10MYBoston Executive Helicopters LLC · Norwood, MAN10SPState Of Kentucky · Frankfort, KYN10TVHelicopters Inc · Cahokia, ILN1102DAviation Advantage Inc · Tabor City, NCN1103LAviation Advantage Inc · Tabor City, NCN11056Northwest Helicopters I Inc · Olympia, WAN110GLQualitair LLC Trustee · MichelstadtN110LTLt Aviation LLC · Louisa, KYN110WGMeshoppen Air LLC · Tunkhannock, PAN111ADSvp LLC · Missoula, MTN111HFPlane Fun Inc Tr Trustee · Snellville, GAN111PMTri Rotor Spray And Chemical · Ulysses, KSN111SPState Of Michigan · Lansing, MIN1128SAerial Organics LLC · Wilmington, DEN112LPRanger Aviation Leasing LLC · Wilmington, DEN113RLMarks Aviation Group LLC · Lafayette, LAN114GSAviation Company Inc · Cheyenne, WYN114HDWindward Aviation Inc · Puunene, HIN114SFN179sf LLC · Chandler, AZN1158BAir Gov 1 LLC · Rome, NYN115ECSara Helicopters Inc · Wilmington, DEN115HDLaroche Aviation Services LLC · Bellaire, OHN115SUSignature Property Holdings LLC · Wilmington, DEN1171Agricultural Air Services LLC · Jupiter, FLN117HKSettan Corp · Goleta, CAN118AEAir Evac Ems Inc · O Fallon, MON118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN118TVInterstate Helicopter Inc · Bethany, OKN119AEAir Evac Ems Inc · O Fallon, MON119TTaylor 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, KS
Back to AD 2018-13-01