AD 2018-04-13
Registered aircraft · 1,373
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-04-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:2018-04-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:2018-04-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:2018-04-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.
N4752WNobska LLC · New Castle, DEN475PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN476FXPrc Partners LLC · Cleveland, OHN477RTRtr Express LLC · Marshfield, WIN477SCRegistered aircraftN479PFGenmark Ventures LLC · Boca Raton, FLN480CBComerica Leasing Corp · Dallas, TXN482RSPraetor Ssi LLC · Lighthouse Point, FLN484EMRegistered aircraftN487JAJ & Ak Aviation LLC · Kansas City, MON488VCOaklr LLC · New York, NYN495ECEdwards Challenger 300 LLC · Columbus, OHN4BZPalmetto Construction Group III LLC · Sumter, SCN4MXB&G Air Inc · Morgan City, LAN500CGAmalgamated Consolidated LLC · Pittsburgh, PAN500FXFlexjet LLC · Cleveland, OHN500MLBarkley Services LLC · Beaverton, ORN500NBRegistered aircraftN500RRegistered aircraftN500RPPts As LLC · New Castle, DEN500VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN501FXFlexjet LLC · Cleveland, OHN501KAAllen Aircraft Equipment LLC · Valparaiso, INN502FX95 Management LLC · Cleveland, OHN502RPOmicron Transportation Inc · New Castle, DEN503FXFlexjet LLC · Cleveland, OHN503KJCrawford Leasing Company LLC · Wichita, KSN504FXFlexjet LLC · Cleveland, OHN504RPPts As LLC · Reading, PAN505FXFlexjet LLC · Cleveland, OHN506FXFlexjet LLC · Cleveland, OHN506RPPts As LLC · Reading, PAN507FXSempra Energy · Cleveland, OHN507RPPts As LLC · New Castle, DEN508FXFlexjet LLC · Cleveland, OHN508XJBank Of Utah Trustee · Salt Lake City, UTN509EEBank Of Utah Trustee · Salt Lake City, UTN509FXFlexjet LLC · Cleveland, OHN509SBSbco Cj3 LLC · Denver, CON50LFLeprino Foods Co · Denver, CON510FXFlexjet LLC · Cleveland, OHN510SEStar Chaser LLC · Owensboro, KYN511FCMaryland Group LLC · Saint Louis, MON511FXFlexjet LLC · Cleveland, OHN512FXFlexjet LLC · Cleveland, OHN513CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN513FXMotorola Solutions Inc · Cleveland, OHN513MGMgpg Management LLC · San Diego, CAN514FXBanks Lee C Trustee · Cleveland, OHN514TXIe Aviation LLC · Price, UT
Back to AD 2018-04-13