Registered aircraft · 40,473

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

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') ORDER BY n_number

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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539 N42917Afmr Inc · Dover, DEBuilt 1991 · S/N 2691 N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95 N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656 N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036 N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406 N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45 N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040 N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603 N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134 N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99 N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549 N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050 N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555 N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799 N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558 N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99 N429DRConard John C · Minnetonka, MNS/N 60412 N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188 N429KERegistered aircraftBuilt 1998 · S/N 52352 N42AKGerhardt David · Denver, COBuilt 1998 · S/N 1434 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42ARAtlantic Aircraft Holdings LLC · Bohemia, NYBuilt 1979 · S/N AA5B1285 N42BLRainey Steven M · Rosamond, CAFirst renewal noticeBuilt 2003 · S/N 2899 N42CMMazor Chris · Belleville, MIS/N 17266374 N42DGHavard Gregory H · Conway, ARBuilt 1989 · S/N 1 N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 1965 · S/N 15061252 N42FYSchwartz David W · Labelle, FLBuilt 1998 · S/N 01 N42GFGillespie Dennis M · Orange Park, FLBuilt 2001 · S/N 23925 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N42KANorth Little Rock Air Inc · North Little Rock, ARBuilt 1966 · S/N 28-3702 N42KRDonnelly Charles A · Browns Mills, NJBuilt 1977 · S/N 28-7716295 N42KSSink Kreth H · Scott Depot, WVBuilt 1992 · S/N 2205 N42PBPfister Mark A · Acworth, GABuilt 1960 · S/N 23-1895 N42PEDennis Kevin M · Bend, ORBuilt 2007 · S/N 90804 N42RRWalla Walla University · College Place, WAS/N ME-84 N42SPCw Air LLC · Broken Bow, NEBuilt 1974 · S/N 28-7415437 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703

Back to AD 80-04-03 R2