AD 2017-17-13
Registered aircraft · 883
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-17-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:2017-17-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:2017-17-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:2017-17-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.
N608KHIronwood Sky Holdings LLC · Wilmington, DEN608RPWheels Up Partners LLC · New York, NYN60CKJurie Jet LLC · Frederick, MDN610CGMac Air LLC · Sellersburg, INN610HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN611AVCyprus Center Services LLC · Gilbert, AZN613LSCarlton Place Leasing LLC · Boca Raton, FLN614WDCharlie 350 LLC · Columbus, OHN615WDCharlie 300 LLC · Columbus, OHN621PPPpc Excursions Inc · Lancaster, PAN622NNicholas Services LLC · Oxford, MSN623NNicholas Services LLC · Oxford, MSN627EEBluestone 214 LLC · Richmond, VAN630ABBerlin Aviation LLC · Glencoe, ILN631RPJsv Aviation Ventures 631 LLC · Dallas, TXN632BALebeouf Bros Towing LLC · Bourg, LAN633NNicholas Services LLC · Oxford, MSN633TXMarquis Asset Leasing LLC · Dallas, TXN636RHGuarantee Management Services LLC · Glenview, ILN63WRFour S'S LLC · Greenville, NCN642DMMiller Challenger LLC · Dallas, TXN670CPSalep Corp · Miami, FLN672DEAir Persistence LLC · Boston, MAN672PPRegistered aircraftN673PPRegistered aircraftN674EFEdinton Holdings USA Inc · Miami, FLN675LCRockies West LLC · Eugene, ORN685ARBua Delaware Inc · Wilmington, DEN686CBTvpx Ars Inc Trustee · North Salt Lake, UTN686CGRegistered aircraftN693MRMmr West LLC · Salem, ORN695BAFlying Strategies LLC · Garland, TXN697CMTvpx Aircraft Solutions Trustee · North Salt Lake, UTN699PBSuperior Products 2 LLC · South Plainfield, NJN700BCTvpx Trust Co LLC Trustee · North Salt Lake, UTN700QSRegistered aircraftN7011MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN701QSRegistered aircraftN702QSRegistered aircraftN702RWEcl Leasing LLC · Las Vegas, NVN703QSRegistered aircraftN704JBJimmie Johnson Racing II Inc · Birmingham, MIN705QSRegistered aircraftN706QSRegistered aircraftN707KGBbhco LLC · Los Angeles, CAN707MHDrg Challenge LLC · Sonoma, CAN707QSNetjets Sales Inc · Oklahoma City, OKN707SCS Cole Aviation LLC · Midland, TXN707SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN708CFCottonwood Investment Group LLC · Sleepy Eye, MN
Back to AD 2017-17-13