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.
N68567Goldbach Charles H · Valleyford, WAN6856BEberly Joshua D · Middletown, OHN6856JWancho Brian J · El Paso, TXN6856KWyborny Elton D · Scotland, ARN6856NTagle Robert J II · San Antonio, TXN6856WRogers Kevin Shane · Highland Village, TXN68570Chmiel John P · Wausau, WIN68572Precision Guided Solutions LLC · Sioux Falls, SDN68573Etherington Sara L · Belton, MON68574All Attitude Aviation Inc · Edgewater, FLN68575Kushner Herbert A · Bridgewater, NJN68576Robinson Neil A · Madison, WIN68579Schaefer Gerard P · Olive Branch, MSN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6857STailgate LLC · Felton, GAN6857UShabotynskyj Kathleen · Palm City, FLN6857WN6857w Inc · Palos Heights, ILN6858DSeratt Tim · Harviell, MON6858HPrairie Skies Aviation LLC · Hutchinson, KSN6858KPreston Benjamin J · Sonoma, CAN6858NBarnes Kevin Lee · Greensboro, MDN6858UMattingly James P · Edwardsville, ILN6859HRoeper Gary Lee · Linden, MIN6859JDobberfuhl Roy · Cedarburg, WIN6859KShelton Gregory S · Midlothian, VAN6859NLozar Dianne C · La Harpe, ILN6859PPlowman Joseph E · Longmont, CON6859UFischer John C · North Highlands, CAN685ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN685CXFitzgerald David Trustee · Napa, CAN685FLDadson Tach LLC · Mesa, AZN685JAYale Companies LLC DBA · Indianapolis, INN685JBMichels David A · Louisville, KYN685JWGiurtino Joel F · Spring Hill, FLN685LHChristiansen Aviation LLC · Wilmington, DEN685MAYale Companies LLC DBA · Indianapolis, INN685NDUnd Aerospace Foundation · Grand Forks, NDN685SPDirty Side Down Aviation LLC · Georgetown, TXN68608Oxford Aircraft Leasing LLC · Oxford, NCN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6860JApm Leasing LLC · Casper, WYN6861HViking Systems Inc · Naples, FLN6861JEwart Mark A · Shoreacres, TXN6861NCooke Douglas L · Ventura, CAN6861WLoffeimancher Richard P · Eastvale, CAN6862HStrickland J A · Fairbanks, AKN6862JTraut Joseph W · Sharon, MAN6862UCromer Chet T · Anderson, SCN6862WFly Dynasty Corp · Ocala, FLN6863FKaminski Joseph J · Port Orange, FL
Back to AD 90-04-06 R1