Registered aircraft · 40,472

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.

N18ZMays Paul R · Toney, ALBuilt 1971 · S/N 394 N18ZBBailey John Bryan · Eagle River, AKBuilt 1977 · S/N 18-7809054 N18ZZGardom Brandon D · Spirit Lake, IDBuilt 1959 · S/N 18-3380 N1900PHauff Delmar M · Julesburg, COBuilt 1955 · S/N 22-2647 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162 N1900YMarrero Francisco J · Lake Charles, LABuilt 1964 · S/N 2684 N1900ZChavey Gary G · Manchester, MIBuilt 1984 · S/N 8024C N1901AHatbright Farm LLC · Wilmington, DEBuilt 1977 · S/N VAC-81-77 N1901HLuing Daniel M · Chippewa Falls, WIBuilt 1977 · S/N 28-7716059 N1902HAbraxis Air LLC · Casa Grande, AZBuilt 1977 · S/N 28-7716060 N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351 N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352 N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788 N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789 N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493 N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556 N1909KKeith Russell A · Lewiston, MEBuilt 2009 · S/N 91135 N1909UBranch Stephanie B · Papillion, NEBuilt 1974 · S/N 28-7425215 N1909YDuncan Lori Ann · New Tazewell, TNBuilt 1964 · S/N 204 N190AGCarson Ryan P · Albuquerque, NMBuilt 1990 · S/N 10000 N190BTHitchcock Aviation LLC · Twin Falls, IDBuilt 1981 · S/N 18-8109058 N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103 N190RROrr John C · Longmont, COBuilt 1997 · S/N 23039 N19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557 N1910PWesley Gary J · Moorland, IABuilt 1955 · S/N 22-2657 N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464 N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205 N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559 N1911PWalker Raymond Lee · Saint Charles, MIBuilt 1955 · S/N 22-2590 N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412 N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103 N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207 N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061 N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474 N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208 N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062 N1914LDeakins Glenn F · Ringgold, GAS/N MB-803 N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792 N1915AMercatoris Robert B · Meadville, PABuilt 1952 · S/N 18-1756 N1915PParker Joshua J · Hawley, TXBuilt 1955 · S/N 22-2662 N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210 N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211 N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817 N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212 N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813 N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794 N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794 N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011 N1919PBarnett David K · Brock, TXS/N 22-2666 N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899

Back to AD 80-04-03 R2