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.
N515MJFleet Two LLC · Beverly Hills, CAN517RPSl Global 2026 LLC · Basking Ridge, NJN518DDDcs Aviation LLC · Dallas, TXN519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN51SETps LLC · Medina, WAN528MPCr Holdings LLC · Crystal Lake, ILN529DBHardwicke Properties LLC · Houston, TXN530KCRegistered aircraftN53GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN543GLSkechers USA Inc · Manhattan Beach, CAN545BZAv Logistics LLC · Cheshire, CTN54DPGps 1 LLC · Tampa, FLN550RLNew Prime Inc · Springfield, MON551SWSn 9086 LLC · Wilmington, DEN552YMWilmington Trust Co Trustee · Wilmington, DEN554AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555HDDkh Services LLC · Salt Lake City, UTN555PVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN560UCsms Management LLC · Pearland, TXN561RLAgile Equipment Leasing LLC · Wilmington, DEN562THGlobal One Tjh LLC · San Antonio, TXN564DXDsg Finance LLC · Coraopolis, PAN569DC56 Holdings LLC · Las Vegas, NVN575BGWmb Global 2018 LLC · Opa Locka, FLN5883Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN588CV9354 Leasing LLC · West Palm Beach, FLN590EAurora Aircraft LLC · Waterford, MIN590MSMartin Sprocket & Gear Inc · Arlington, TXN591SRIsr Platforms LLC · Mclean, VAN595ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN595MPEoc Consulting LLC · Salt Lake City, UTN599CETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN59DBConstellation Productions Inc · Jacksonville, FLN600JVJsv Leasing III LLC · Orlando, FLN600NBCisco Aero - N9781 LLC · Cisco, TXN603SVSv Solutions LLC · Ketchum, IDN604BDL3harris Technologies Flight Capital LLC · Greenville, TXN606TDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN609AKPeck Ventures LLC · Henderson, NVN609JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN609RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN60BJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN60CCRegistered aircraftN610AWMs Hawker LLC · Farmington Hills, MIN610CXGlobal 9066 LLC · Wilmington, DEN610SWSteel Services Ltd · New York, NYN611BFAmb Group LLC · Atlanta, GAN611GJBank Of Utah Trustee · Salt Lake City, UTN615TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2020-03-21