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.

N180PZBertholl Dwayne R · Eagle River, AKBuilt 1963 · S/N 18-8075 N180RGBorg James A · Lindstrom, MNBuilt 1985 · S/N 987 N180VASmith Trevor A · Justin, TXBuilt 2002 · S/N 897 N180VBPersons Richard A · Arroyo Grande, CABuilt 2003 · S/N 5307 N1810PTurner Christian Millard · Eastsound, WABuilt 1955 · S/N 22-2589 N1811JJonas Christian R · Corpus Christi, TXBuilt 1968 · S/N 28-24239 N1812Marsh John E · Washington, DCS/N RG-1 N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530 N1812JEcho Aviation II LLC · Akron, OHBuilt 1968 · S/N 28-24240 N1812PCarothers Edward L · Jersey Shore, PABuilt 1955 · S/N 22-2591 N1813JSale Reported · Princeton, MNSale reportedBuilt 1968 · S/N 28-24242 N18141Schulte James P · Hurst, TXBuilt 1951 · S/N 181332 N1814DAndover Flight School Inc · Andover, NJBuilt 1958 · S/N 18-6406 N1814JGunn John R · Eloy, AZBuilt 1968 · S/N 28-24243 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N1815JDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N 28-24244 N1816TGq Aviation LLC · Cherry Hill, NJBuilt 1971 · S/N 28-7125173 N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N1817JCarey Thomas W Jr · Springfield, ILBuilt 1968 · S/N 28-24247 N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142 N18184Lerille Red · Lafayette, LABuilt 1941 · S/N A-810 N18186Davies Samuel R · Port Angeles, WAS/N A-812 N1818JDavey Aaron A · Topeka, KSBuilt 1968 · S/N 28-24248 N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143 N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705 N1819BDudinsky Todd M · Eagle River, AKS/N 20008C N181BAClough James Erwin · Pittsboro, NCBuilt 1981 · S/N 28-8116230 N181BHAeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N 28-8390003 N181CCrume Christopher C · Englewood, FLBuilt 1960 · S/N TD-440 N181DJNew England Aviation LLC · Plainville, CTBuilt 1977 · S/N 28-7790415 N181FBaker Myron C · Morrow, OHRegistration revokedBuilt 1959 · S/N 226705 N181FATriangle Aviators LLC · Cary, NCBuilt 1983 · S/N 288390062 N181GBBartel Gary W · Tucson, AZBuilt 1979 · S/N 28-7990275 N181GPPilots Flying School LLC · Manalapan, NJBuilt 1984 · S/N 28-8490061 N181HEOzziac Enterprises Inc · Huron, OHBuilt 1988 · S/N 2890078 N181LEast Atlantic LLC · Helena, MTS/N 20001C N181MHHurd Mark A · Bono, ARBuilt 1979 · S/N 28-7990279 N181PDAnderson Christopher · Wilmington, NCBuilt 1978 · S/N 28-7890462 N181PGSkybound Aviation LLC · Kernersville, NCBuilt 1977 · S/N 28-7790584 N181REJacobsen Gary J · Yelm, WABuilt 1996 · S/N 195 N181RJUaa International Inc · La Verne, CABuilt 1980 · S/N 28-8190106 N181TBVector Aviation LLC · Mentor, OHBuilt 1978 · S/N 28-7990212 N181TCDezendorf Thomas C · Petaluma, CABuilt 1979 · S/N 28-7990324 N181TKAnderson Brad A · Rochester, MNBuilt 1977 · S/N 28-7890193 N181TMEichhorn Scott William · Searcy, ARS/N 114-74 N181TSJls Aviation LLC · Sarasota, FLBuilt 1975 · S/N 28-7690062 N181WFNorton Thomas W · Dayton, NVBuilt 1977 · S/N 28-7890116 N181WGFlycasual LLC · Bloomington, ILBuilt 1984 · S/N 28-8490069

Back to AD 80-04-03 R2