AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N77XYExtra Sweet LLC · Saint Paul, MNN77XZRed Rocket Holding Co LLC · Boca Raton, FLN77YACrew Sourcing Inc · Wilmington, DEN77YMNew Richard A · Deming, WAN77YWMeske Richard A · Columbus, OHN77ZCWorkman Randall L · Batavia, OHN77ZPTryer Vince S · Wilmington, NCN77ZWMeyer Alan T · Eckert, CON7800DGoff Harold G · Brandon, FLN7800GSale Reported · Roseville, MNSale reported, pending cancellationN7800PPash Olin M · Harlan, IAN7800SSlykerman John A · Bakersfield, CAN7801DWebb John M · Chugiak, AKN7801HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN7801NGeorge Monte · Medford, ORN7801SRital Copter Service Inc · Hudson, IAN7801WRegistered aircraftN78027Cramlet Kirk T · Woodlake, CAN7802VKruger Matthew J · San Francisco, CAN7803DFako John · Binghamton, NYN7803FKarlovich James W · Kingston, GAN7803GTomlin Jonathan S · Georgetown, OHN7803VArtlip James · Wake Forest, NCN7803W3w Group Inc · Hot Springs, ARN78048Latham Randall W · Georgetown, OHN7804GWells Adam · New Lexington, OHN7804NApaa Aviation Group LLC · Frisco, TXN7804VVickers David Dewayne · Douglas, GAN78051Sipple Ronald W Jr · Gardner, KSN7805DMoretti Anthony · Deming, NMN7805GArgabright John · Waterford, OHN7805NCorrigan Air Center · Hondo, TXN7805YN7805y LLC · Winchester, VAN78066Orlandi Properties LLC · Blairstown, NJN7806DHillegeist Tracy L · Beverly, KSN7806GAircraft Management Services Inc · Milton, FLN7806NTab Air Time LLC · Longmont, CON7806PSpires Kenneth G · Seville, OHN7806VMouriz Javier · Leesburg, FLN7806YHhozapnv-LLC · Las Vegas, NVN78074Bartholomew Donald B · Gardnerville, NVN78076Clinton Aeroclub · Clinton, IAN78078International Air Services Inc Trustee · Carson City, NVN7807GLake Of The Woods Aviation LLC · Baudette, MNN7807NBwh Leasing LLC · Lewes, DEN7807SSmith Travis T · Watsonville, CAN7807VMad Dog Aviation LLC · Minot, NDN7807YMcv2021 LLC · Saint Augustine, FLN78083Holcomb Garry · Point, TXN78086Drake Ronald N · Helena, MT
Back to AD 90-04-06 R1