AD 2020-03-21
Registered aircraft · 523
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:2020-03-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21')
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:2020-03-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21') 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.
N797KBBank Of Utah Trustee · Salt Lake City, UTN799GSSms 111 LLC · New York, NYN799JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN79AYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7CGCoulson Aviation (USA) Inc · Portland, ORN7CSN7cs LLC · Fort Wayne, INN800HCSouthern Valhalla Air LLC · The Colony, TXN800WGWilmington Trust Co Trustee · Wilmington, DEN801PNSabrina Aviation Corp · Boston, MAN802BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN806HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN807DCFj 900 Inc · Dulles, VAN809DCFj 900 Inc · Dulles, VAN80TEBank Of Utah Trustee · Salt Lake City, UTN810CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN81118Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN814RGWilmington Trust Co Trustee · Wilmington, DEN816TJBombardier Aerospace Corp · Dallas, TXN817KLKak Transportation 5500 LLC · Carlsbad, CAN818AATvpx Ars Inc Trustee · North Salt Lake, UTN821AMJoust Capital II LLC · Potomac, MDN822VPVp LLC · Camden, DEN825FSGlobalgriffin LLC · Belgrade, MTN827TFAvandra LLC · Salt Lake City, UTN82EMJdi Holdings LLC · Allentown, PAN82HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN832PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN83WGCooper Burger LLC · Coral Gables, FLN843FFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN843GXAlesant Air LLC · Miami, FLN84YUTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN858DLPnc Financial Services Group Inc · Pittsburgh, PAN85DRegistered aircraftN863CMWeh 601 LLC · Wilmington, DEN864JGBowtie Aircraft Xrs LLC · Aventura, FLN8762MWilmington Trust Co Trustee · Wilmington, DEN878SCTvpx Ars Inc Trustee · North Salt Lake, UTN880JVBank Of Utah Trustee · Salt Lake City, UTN880XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN886BPSun Air Three LLC · Scottsdale, AZN888VSBank Of Utah Trustee · Salt Lake City, UTN889PGPrima Air Inc · Pasadena, CAN889STBank Of Utah Trustee · Salt Lake City, UTN88STTvpx Aircraft Solutions Trustee · North Salt Lake, UTN898MDepartment Of The Air Force · Bedford, MAN898WSWilmington Trust Co Trustee · Wilmington, DEN89CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8VBCbs Mass Media Corp · Van Nuys, CAN900GXHrznar LLC · Dallas, TX
Back to AD 2020-03-21