AD 2017-04-01
Registered aircraft · 377
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-04-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:2017-04-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:2017-04-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:2017-04-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.
N595BCsc Delaware Trust Co Trustee · Wilmington, DEN595TGPlatinum Equity LLC · Beverly Hills, CAN5AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN606SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN609WBDiscovery Communications LLC · New York, NYN60CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN611PLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN613HBSigma Equity LLC · San Francisco, CAN615CPRegistered aircraftN618PBMaurice James Airplane LLC · Salt Lake City, UTN61WXBank Of Utah Trustee · Salt Lake City, UTN625FJFertitta Entertainment Holdings LLC · Houston, TXN628TSFalcon Landing LLC · Hawthorne, CAN630MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN631CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN63HSHs Arrow LLC · Indianapolis, INN63XFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6453Tvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTN645DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN647GDRegistered aircraftN-number assigned (import), not yet registeredN648JPRegistered aircraftN6505RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650AFVulcan Aircraft Inc · Seattle, WAN650ALRegistered aircraftN650ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650BRWilmington Trust Co Trustee · Wilmington, DEN650CRegistered aircraftN650DWarbler I LLC · Freeland, MIN650DAG650 Operating LLC · College Station, TXN650DYPj Holdco LLC · New York, NYN650EBRegistered aircraftN650EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650ERBank Of Utah Trustee · Salt Lake City, UTN650EWEwa West LLC · San Jose, CAN650FJFertitta Entertainment Holdings LLC · Houston, TXN650FXFlexjet LLC · Cleveland, OHN650FZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650GBAmerican Express Travel Related Services Co Inc · New Windsor, NYN650GUMpm Financial LLC · Beverly Hills, CAN650GWOzora Inc · Wilmington, DEN650GXGulfstream Leasing LLC · Savannah, GAN650HARegistered aircraftN650HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650HFRegistered aircraftN650KJAirtime LLC · New York, NYN650KTMockingbird Air LLC · Centennial, CON650MTTmnn Manager LLC · San Antonio, TXN650MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650NB650 Nb LLC · Chicago, IL
Back to AD 2017-04-01