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.

N6MHPaquette Daniel J · Belleville, MIFirst renewal noticeBuilt 1950 · S/N 155N6MXHale Mitchell D · Palmer, AKS/N 18-6650N6NGAvalle Carlos A · Livermore, CABuilt 1983 · S/N 180N6NHStephens Timothy D · Springfield, MOBuilt 1966 · S/N 28-3698N6NSWestern Flying Club Inc · Burlington, NCBuilt 1978 · S/N 28-7990206N6PFSoplanda Matthew J · Willow, AKBuilt 1952 · S/N 18-2007N6PMGoode Max T · Mariposa, CAFirst renewal noticeBuilt 2001 · S/N 001N6PTStrange Jim · Tyler, TXBuilt 1973 · S/N 2066N6PUMoreno Juan T · Stockbridge, GABuilt 2002 · S/N 25038N6QKRobb Jeffery A · Hebron, OHBuilt 1982 · S/N WA-306N6QUHoward Timothy D · Port Orange, FLBuilt 2012 · S/N 001N6RRegistered aircraftBuilt 1999 · S/N 21946N6RBBush Robert · Landisville, PABuilt 1977 · S/N 0015N6RESouthwest Lakes Experience LLC · Sawyer, MIS/N 105N6RXG&M Aviation LLC · Kokomo, INBuilt 1989 · S/N 1053N6SBFranklin Gary · Willow Beach, AZS/N 1080N6SGCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0878N6SKKilpatrick L Shawn · Hartwell, GABuilt 2002 · S/N 2098N6SYKirkpatrick Andrew T · Corpus Christi, TXBuilt 1975 · S/N AA5B-0210N6TAGarrard Walter E · Elbert, COBuilt 2000 · S/N 24533N6TDCapouch Michael J · Medaryville, INBuilt 1975 · S/N 18-7509108N6TVTravelaire Service Inc · Wilmington, DES/N 17275278N6UKN6uk LLC · Goshen, INBuilt 1978 · S/N 32-7840123N6UULoerzel James E · Arlington Heights, ILBuilt 2005 · S/N 25887N6VDEllison Jeremy · Dayton, NVBuilt 1981 · S/N A7354CN6VKQuagmire LLC · Hurricane, UTBuilt 2008 · S/N DMO-263N6WChase Roy M · Limington, MEBuilt 1970 · S/N 29PN6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676N6WEHigh Flight Aviation LLC · Harwinton, CTBuilt 1993 · S/N 3213050N6WNDart Gregory G · Mayville, NYS/N 198N6WRCueva Arturo A · Los Angeles, CABuilt 1978 · S/N 001N6XAFlying Farmers LLC · Dalhart, TXBuilt 1997 · S/N 1366N6XCNorthstar Aerospray Inc · Clara City, MNBuilt 1997 · S/N 1383N6XLCrowe Donald L · Mcallen, TXBuilt 1986 · S/N MHS-1985N6XQAccuracy 1st · Canadian, TXBuilt 1999 · S/N 2026N6YEExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1997 · S/N 2557N6YGArcher Project Management LLC · Forney, TXBuilt 2003 · S/N 25903N6YLHolman Leasing LLC · Anchorage, AKS/N 301162N6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 30-572N6YQBeek Dudley E · Miami, FLBuilt 1994 · S/N 451N6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIBuilt 2003 · S/N 1348N6YTCassinelli Steven W · Oceanside, ORBuilt 2002 · S/N 2198N6YVZadrozny Pedro A · Wellington, FLBuilt 1978 · S/N 32R-7885160N6ZHarris Hayden H · Chelsea, MIBuilt 1980 · S/N JM-2N6ZGTta Logistics LLC · Christiansted, VIBuilt 1968 · S/N 27-3872N6ZHPetranek Diana C · Albion, NYBuilt 2000 · S/N PMG002N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020N6ZRBreed Paul T · Solana Beach, CABuilt 1980 · S/N 61P07168063346N6ZTLewis Eddy L · Cortez, COBuilt 1957 · S/N 18-5824N700Dailey Jeffrey D · Weirton, WVBuilt 1971 · S/N 317-71
Back to AD 81-18-04 R2