AD 2020-21-21
Registered aircraft · 308
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-21-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-21-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-21-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-21-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.
N58CMCrystal Motorsports LLC · Crystal River, FLN596LFHaynes Life Flight LLC · Wetumpka, ALN59PDiesel Acquisitions LLC · Milpitas, CAN59ZXAs 355 LLC · Gay, GAN5UVPortlock Aviation LLC · Mansfield, TXN613HAHa 109e LLC · Flushing, NYN618HRBoardwalk Air I LLC · Atlantic City, NJN621SCSouth Bay Helicopter Service Inc · Hayward, CAN631HCIntermountain Medical Transport LLC · Salt Lake City, UTN648SHAltus Aviation Management · Las Vegas, NVNon-citizen corporation, flight hours not reportedN651MCMercy Flight Central Holding LLC · Canandaigua, NYN656LFTroy Equipment Holdings LLC · Houston, TXN65CJBank Of Utah Trustee · Salt Lake City, UTN663SSLeonardo Helicopters US Corp · Philadelphia, PAN669SSLeonardo Helicopters US Corp · Philadelphia, PAN671MHMansfield Heliflight Inc · Milton, VTN68NMNorth Memorial Healthcare · Brooklyn Center, MNN69KGBank Of Utah Owner Trustee · Salt Lake City, UTN6JEEurotec Vertical Flight Solutions LLC · Eudora, KSN6VZLeonardo Helicopters US Corp · Philadelphia, PAN703SHNaval Air Systems Command · Patuxent River, MDN705SHNaval Air Systems Command · Patuxent River, MDN706SHNaval Air Systems Command · Patuxent River, MDN709CGBristow LLC · Lake Charles, LAN712MCMercy Flight Central Holding LLC · Canandaigua, NYN715RTBristow LLC · Lake Charles, LAN71NMNorth Memorial Health Care · Brooklyn Center, MNN726LFBank Of Utah Trustee · Salt Lake City, UTN72HRSeminole Tribe Of Florida DBA · Davie, FLN72SLMhm Logistics LLC · Wilmington, DEN731HCIntermountain Medical Transport LLC · Salt Lake City, UTN73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN749SDRocklyn Leasing LLC · Duluth, GAN756LFBank Of Utah Trustee · Salt Lake City, UTN75GGA109s LLC · Pinecrest, FLN770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN776LFKeybank Na · Superior, CON786LFKeybank Na · Superior, CON786MKAviation Trust Co LLC Trustee · Oklahoma City, OKN789RTIntegrity Aircraft Title Holdings LLC · Portland, ORN78LFMercy Health Life Flight Network LLC · Toledo, OHN794DMRed River Aircraft Leasing LLC · Anchorage, AKN7ADEurotec Vertical Flight Solutions LLC · Eudora, KSN7UCRegistration Pending · Greenwood Village, CORegistration pendingN802SMBristow LLC · Lake Charles, LAN808STNaval Air Systems Command · Patuxent River, MDN80NYWgb Holdings LLC · Sparta, NJN80PJBank Of Utah Trustee · Salt Lake City, UTN810MCMercy Flight Central Holding LLC · Canandaigua, NYN810STNaval Air Systems Command · Patuxent River, MD
Back to AD 2020-21-21