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.
N900SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN901GXUnited States Air Force · Bedford, MAN9045United States Air Force · Bedford, MAN9046United States Government · Bedford, MAN9047United States Government · Bedford, MAN9048GUnited States Air Force · Bedford, MAN905JGLion Sky Aviation LLC · Studio City, CAN907GXLearjet Inc · Wichita, KSNon-citizen corporation, flight hours not reportedN907PHShore Capital Aviation LLC · Chicago, ILN907WSN907ws Aviation LLC · Honolulu, HIN909ZMMoelis & Company Manager LLC · Los Angeles, CAN90FXCitation X Parts LLC · Liberty, NCN90LEEstein Aviation LLC · Orlando, FLN9103JSn 9103 LLC · Dover, DEN9125XDodson International Parts Inc · Rantoul, KSN912MTUS Bank Na · Marshall, MNN9130Alliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN915JGBank Of Utah Trustee · Salt Lake City, UTN916MXWilmington Trust Co Trustee · Wilmington, DEN917RPadaca Global LLC · Hollywood, FLN918DBHdb Holdings LLC · Dallas, TXN918TBScout Aviation IV LLC · New York, NYN919EMTvpx Trust Co LLC Trustee · North Salt Lake, UTN925GTenax Aerospace LLC · Ridgeland, MSN926PNSn 9003 LLC · Van Nuys, CAN92FXFlexjet LLC · Cleveland, OHN930ENE Management LLC · New York, NYN930FTSierra Nevada Company LLC · Sparks, NVN933EYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN933MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN934JMMch Air LLC · New York, NYN939APRegistered aircraftN939GSRegistered aircraftN939MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN944GL9443 LLC · Fort Lee, NJN944MMTc Flight LLC · San Francisco, CAN9506GUnited States Government · Hanscom Afb, MAN950MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN954JJSn 9103 LLC · Dover, DEN954LRegistered aircraftN954SPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN956WSWilliams-Sonoma Stores Inc · San Francisco, CAN958JGDiamond Aviation LLC · Dublin, GAN959KFKw Flight LLC · Bozeman, MTN963JPLeila Management Inc · San Francisco, CAN968BXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN969EPTvpx Ars Inc Trustee · North Salt Lake, UTN969FBUmb Bank Na · Salt Lake City, UTN96APTwo Creeks Partners LLC · Farmingdale, NYN96FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2020-03-21