AD 81-18-04 R2

Registered aircraft · 81,733

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: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.

N6144DCarter Tim R · Morgan, UTBuilt 1957 · S/N 22-4788N6144LArtz Agri Sales LLC · Westhope, NDBuilt 1980 · S/N 15284364N6144MBargabos Richard O · Peterboro, NYBuilt 1978 · S/N 7169CN6144NDunn Rick · Benton, ARS/N MB-415N6144VAir Flite Inc · Shawnee, OKBuilt 1996 · S/N 0037N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162N61455Hutcheson David Carl · Santa Rosa Beach, FLBuilt 2004 · S/N 18281363N61458Dls Holdings Inc · Lewes, DEBuilt 1995 · S/N 0008N6145DLindsey Christopher T · Nesbit, MSBuilt 1957 · S/N 22-4789N6145LMichaud Martin R · Monte Vista, CABuilt 1970 · S/N AA1-0345N6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXBuilt 1980 · S/N R18201625N6145VMarshall University · Huntington, WVBuilt 1996 · S/N 0045N6145WRegistered aircraftS/N 28-20163N61465Bishop Michael D · Pulaski, TNS/N 12-3189N61468Nimmons Johnny F · Brookshire, TXBuilt 1943 · S/N L424ARN6146PMount Up Aviation LLC · Kirbyville, MOS/N 24-1247N6146QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1981 · S/N 15285169N61474Harper Analeasa Leighan · Clarksville, TNBuilt 2004 · S/N 18281370N6147DRegistered aircraftBuilt 1957 · S/N 22-4792N6147EBuckley Michael J · Billings, MTBuilt 1995 · S/N S1707N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229N6147MSix One North LLC · Anchorage, AKBuilt 1978 · S/N 7185CN6147RBloom James F · Clay City, KYS/N 172RG0094N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166N61486Johnson Gary R · Carthage, NYBuilt 1998 · S/N 0084N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230N6148JNorth Texas Flight Ventures LLC · Mckinney, TXBuilt 1976 · S/N 28-7615313N6148LYoukey John N · Yuma, AZBuilt 1970 · S/N AA1-0348N6148NAll-In-Aviation LLC · Paragould, ARBuilt 1969 · S/N M-1225N6148VChupp Aaron · Gallipolis, OHBuilt 1998 · S/N 0086N6148WAir Ventures Flying School LLC · Smithfield, RIBuilt 1964 · S/N 28-20167N6149Witek Edward G · El Cajon, CABuilt 1969 · S/N ET-1N61494Millican Marc J · Anchorage, AKS/N 18-5712N614973 Dudes 1 Plane LLC · Olympia, WABuilt 1976 · S/N 28-7625109N6149JAeroventures Flying Club Inc · Lilburn, GABuilt 1976 · S/N 28-7615314N6149NZappa Tyler M · Hudson, FLBuilt 1969 · S/N M-1226N6149QGreen Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285172N6149SScheller Kenneth R · Glassport, PABuilt 1980 · S/N R18201627N6149TCrawford Iain A · Perkinsville, VTBuilt 1992 · S/N 20303-1JWN6149VFoode Frank J · Cordova, AKBuilt 1980 · S/N 172RG0587N614ACLawless Aviation LLC · Fishers, INBuilt 2001 · S/N 454-2001N614AZWienholt Robert Jr · Perry Hall, MDBuilt 1985 · S/N 17276475N614BGNorth Star Aviation Inc · Mankato, MNBuilt 1980 · S/N 15284205N614BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881856N614BREsch Brian D · Colorado Springs, COBuilt 2016 · S/N 60489N614CGC3 Aircraft LLC · Burnet, TXBuilt 2001 · S/N 9926CCN614DHHall Wilburn H · Fort Payne, ALBuilt 2017 · S/N 23859N614DVSpano David · Oswego, ILBuilt 1984 · S/N 1138N614ECEarwood Edward A · Sonora, TXBuilt 2008 · S/N CC18-0028N614EDClark Richard A · Warren, MIBuilt 2002 · S/N 23102
Back to AD 81-18-04 R2