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.
N616DCDjw Aviation III LLC · Monterey, CAN618WFJetran LLC · Horseshoe Bay, TXN6192BGlacier Aviation LLC · Westlake, TXN620SYGreeneagles LLC · Salt Lake City, UTN622CKN622ck LLC · Sterling, VAN6235DBombardier Aerospace Corp · Dallas, TXN6237DBombardier Aerospace Corp · Dallas, TXN624BPWilmington Trust Co Trustee · Wilmington, DEN624BRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN625SCStryker Corp · Portage, MIN626JJBank Of Utah Trustee · Salt Lake City, UTN626JSJwc Winter LLC · West Palm Beach, FLN628MWN628mw LLC · Salt Lake City, UTN62AFAmerican Fidelity Corp · Oklahoma City, OKN633ABWilmington Trust Co Trustee · Wilmington, DEN636JSJrs Global LLC · Opa Locka, FLN646JCJrs Airco LLC · Miami, FLN646TBBoeing Co · Berkeley, MON64MTWindtop Inc · Dallas, TXN6508Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6509Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650CVVerde Capital Corp · Tempe, AZN650RVTvpx Ars Inc Trustee · North Salt Lake, UTN650RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN650WCRegistered aircraftN-number assigned (import), not yet registeredN65TPAltex LLC · Lincolnwood, ILN65WLWillis Lease Finance Corp · Coconut Creek, FLN661HNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN667BBCsc Delaware Trust Co Trustee · Wilmington, DEN667JDWch Aa Inc · White Plains, NYN668BBCsc Delaware Trust Co Trustee · Wilmington, DEN669TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN672EVBombardier Aerospace Corp · Dallas, TXN68005Mmap LLC · Houston, TXN683SLSl Global LLC · Basking Ridge, NJN684ARB U A Delaware Inc · Wilmington, DEN68889Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN689WMN2fd LLC · Miami Beach, FLN68KPWilmington Trust Co Trustee · Wilmington, DEN690BDBank Of Utah Trustee · Salt Lake City, UTN691BDBank Of Utah Trustee · Salt Lake City, UTN691GLLakeline Aviation LLC · New York, NYN692BDBank Of Utah Trustee · Salt Lake City, UTN692LN900e LLC · Jensen Beach, FLN693BDBank Of Utah Trustee · Salt Lake City, UTN694BDBank Of Utah Trustee · Salt Lake City, UTN695BDBombardier Aerospace Corp · Dallas, TXN696BDRegistered aircraftAssigned (import), pending cancellationN698BDL3harris Technologies Flight Capital LLC · Greenville, TX
Back to AD 2020-03-21