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.
N5072QBuzby Brian J · Wasilla, AKN5072VPolski Randy B · Baltimore, MDN5072WHurst Randall S · Altus, ARN5072ZMunning Doris E Trustee · Sellersburg, INN50733Howlett Brian A · Clarkston, WAN5073HElite Planes LLC · Menifee, CAN5073NPavco Inc · Gig Harbor, WAN5073VSeaton Brad S · Cache, OKN5074MFaddis Ray K · Kingwood, TXN5074PShingledecker Robert K II · Ozark, ARN5074TPate Michael G · Pontotoc, MSN5074WWells Byron R · Bunn, NCN5074XBaker Jim · Hermosa, SDN5075TIllig Petra A · Anchorage, AKN5075VSanders Jodie D · Fort Worth, TXN5075WBores Scott J · Huron, OHN5075XOpjorden Chris T · Litchfield, MNN50762Skyhawk Group · Kent, WAN5076TDriffill Leroy R · Antonito, CON5076XPalmer Bryce P · Chugiak, AKN5076ZBottoms Michael L · Danbury, NCN50770Schlegel Mark W · Waterford, MIN50771Flying Mermaid LLC · Aiea, HIN50772Donnelly Jennifer A · Hackettstown, NJN5077TBerg Sanford B · Lakeville, MNN5077VAdams Ron · Lovell, WYN5077WSkyport Aviation LLC · Birmingham, IAN5077XLussier John A · Greene, RIN5078BWallace Wayne P · Graham, WAN5078PPutnam Andrew L · New Limerick, MEN5078RBlue Goose Aviation Inc · Polson, MTN5078ZPierce Justin P · Conifer, CON5079AHeaton Tykus · Malta, IDN5079ZJohnson Sappa Farms LLC · Stamford, NEN507AFAmeriflyers Of Texas Inc · Addison, TXN507DTThomas Mark R · Clintondale, NYN507FLSpence Ryan · Chicopee, MAN507GCareer Pilot Training LLC · Wilmington, DEN507GBCountry Cabinet Shop Inc · Benton, KSFirst renewal noticeN507GLSky West Aviation Inc Trustee · Albuquerque, NMN507JLLara Jess D · Albuquerque, NMN507JMMagdaleno Joseph M II · Reno, NVN507LSLansing Community College · Mason, MIN507MMLedger Willaim V Jr · Shreveport, LAN507RGMccurdy Paul R · North Falmouth, MAN507RHJones Douglas H · Prather, CAN507SCSpartan Education LLC · Tulsa, OKN507THLeyva Maria · Edgewater, FLN5080WMatzke Kevin T · Gilbert, AZN5080XOber John A · Candor, NY
Back to AD 90-04-06 R1