Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N1760PBartholomew John E · Storm Lake, IABuilt 1954 · S/N 18-4082 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1761AVecchio Alfred J · Emerado, NDBuilt 1952 · S/N 22-490 N1761DAirwest Helicopters Inc · Redlands, CABuilt 2004 · S/N 0191 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109 N1763JTeeter Adam B · Cambridge, MNBuilt 1968 · S/N 28-24183 N1763PHughes Jennetta M · Big Lake, AKBuilt 1954 · S/N 18-4087 N1763TCroft Kevin Wallace · Durant, OKBuilt 1970 · S/N 28-7125082 N1764ALegge Carl D · Wichita, KSBuilt 1952 · S/N 22-495 N1764TTrabold Peter · North Adams, MABuilt 1970 · S/N 28-7125083 N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743 N1765AMurray James A · Wasilla, AKBuilt 1952 · S/N 22-499 N1765JMay Olivia G · Santa Rosa, CABuilt 1968 · S/N 28-24185 N1765PHendry Robert L · Lysite, WYBuilt 1954 · S/N 18-4090 N1765RPlane Pro Aviation LLC · Shelby, NCBuilt 1978 · S/N R18200553 N1765TFlyhome Aviation LLC · Miami, OKBuilt 1970 · S/N 28-7125084 N1766Aftab Younus · Pleasanton, CAS/N NN-1 N1766KDates Edmund H · Red Creek, NYBuilt 1946 · S/N 4493 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744 N1767JHutcheson Jeffrey K · Council Bluffs, IABuilt 1968 · S/N 28-24188 N1768JTrepanier Richard Alain · Benson, AZBuilt 1968 · S/N 28-24189 N1768TButler Thomas E · Arcadia, FLBuilt 1970 · S/N 28-7125087 N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745 N1769PVollendorf William M · Anchorage, AKBuilt 1954 · S/N 18-4107 N1769TCaudle Steve W · Glencoe, ALBuilt 1970 · S/N 28-7125088 N176ASkkaggs Erik · Tupelo, MSBuilt 2001 · S/N 60170 N176AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881988 N176AZVincent T Remcho Phd LLC · Corvallis, ORBuilt 1983 · S/N 1027 N176BCCousins Mark T · Portland, ORS/N ME-269 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496427 N176DBBell Mary E · Cadillac, MIBuilt 1979 · S/N DB-76 N176DJTucker Christopher S · Mesa, AZBuilt 2010 · S/N 80107 N176GRDdx Air LLC · Wyomissing, PABuilt 1976 · S/N AA5B-0348 N176JBDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 2843183 N176LGillam Benjamin H · Acworth, GABuilt 2001 · S/N 142 N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470 N176PCCenterline Thrust LLC · Sarasota, FLBuilt 2005 · S/N 176 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N176WBVincent David R · Hartley, TXBuilt 1976 · S/N 32-7600013 N176WWRegistered aircraftBuilt 2006 · S/N 2377 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N1770BScholz Francis M · Atchison, KSBuilt 1977 · S/N 150-739 N1770TCherryhill Aviation Inc · Freetown, INBuilt 1971 · S/N 28-7125385 N1771AAllen Timothy · Jackson, GAS/N 22-498 N1771PHansen Larry G · Alliance, NEBuilt 1954 · S/N 22-2543 N1771SLange William H · Brandywine, MDBuilt 1999 · S/N 2060 N1772AAllen Jack · Deridder, LABuilt 1956 · S/N 22-502

Back to AD 81-18-04 R2