Registered aircraft · 81,728

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.

N29KRNeill Derek R · Shawnee, OKS/N 274 N29KYBlack Ops Aviation LLC · Moorhead, IABuilt 2007 · S/N 1778 N29LCareer Flyers LLC · Crittenden, KYBuilt 1966 · S/N 28-22418 N29LGCameron Mark · Alpine, WYFirst renewal noticeS/N 184783 N29LKGibbons David · Holmen, WIS/N 177RG0736 N29LLDenver Rock Island Railroad · Commerce City, COBuilt 1976 · S/N 61P-0333-096 N29LPElbert John E · Rohnert Park, CABuilt 1991 · S/N QQ14 N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309 N29NAGula Jason · Scranton, PABuilt 1969 · S/N 28-26246 N29NCBeasley Fred Scott · Tulsa, OKBuilt 1967 · S/N 28-4277 N29NEYankee Helicopters LLC · Plainville, CTBuilt 1987 · S/N 0691M N29PDDonlan Paul V · Bellevue, WABuilt 1992 · S/N 1002 N29PGGroves Morton Dan Patrick · Menlo Park, CABuilt 2003 · S/N 40.341 N29PJCastle Farms Inc · Sunnyside, WABuilt 1996 · S/N S1727 N29PKKillcommons Peter · Independence, ORBuilt 1991 · S/N S 56 N29RADuenner Matthias · Tustin, CABuilt 1971 · S/N AA1A-0108 N29RBAdvantage Aviation Services LLC · South Saint Paul, MNS/N TD-174 N29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 28R-7535269 N29RPBridges Gary N · Vidor, TXBuilt 2001 · S/N DMO380 N29RSN51e Inc · Portland, ORS/N 1514 N29RVKilby Brian C · Newnan, GABuilt 1997 · S/N 22789 N29RXHey Aerial Application Services LLC · Childersburg, ALS/N 3470 N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125 N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583 N29SGMusser Richard J · Lithia, FLBuilt 2009 · S/N 1084-2009 N29SMGarner Hannah L · Tupelo, ARBuilt 2014 · S/N 90578 N29SPPurpera Daryl G · Pride, LAS/N 28R-35695 N29TAPerry Michael R · Maxwell, CABuilt 2002 · S/N 23056 N29TEBessarab Alex · Portland, ORBuilt 1979 · S/N 28-7916397 N29TLTml Aircraft Inc · Narrowsburg, NYBuilt 1976 · S/N 28-7615248 N29TMStichman Thomas Arthur · Grosse Pointe, MIBuilt 1987 · S/N 729 N29TPBray Robert M · Lusby, MDBuilt 2004 · S/N 80547 N29TSBrady George K · Rose Hill, KSBuilt 1990 · S/N 1037-C49 N29VMDragonfly Aviation LLC · Laredo, TXS/N 0368 N29WXIngram Thomas C · Steele, ALBuilt 2025 · S/N 74419 N29WYCouloir Aviation LLC · Missoula, MTBuilt 2010 · S/N 3107 N29XCWunorse Openslae LLC · Dallas, TXBuilt 2017 · S/N CC19-0015 N29YCAg One Aviation LLC · Villa Grove, ILS/N 1809068 N29YDPerry David · Las Vegas, NVS/N 4456 N2AGoodyear Tire & Rubber Co · Akron, OHBuilt 2016 · S/N 007 N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941 N2AEKnestel Tony Kevin · Naples, FLBuilt 1983 · S/N DICKSON-0001 N2AGCentral Air Parts Inc · Staunton, ILBuilt 1972 · S/N 366-72 N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789 N2AMFazio Peter A · Nokomis, FLBuilt 1977 · S/N 24-0156 N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692 N2AXParks Dennis K · Hillsboro, ORBuilt 1994 · S/N 1319 N2AYLawrence Brant E · Paulden, AZS/N 12-1038 N2BJRegistered aircraftN-number assigned, not yet registeredS/N 001 N2BNJensen Paul E · Exeter, NEBuilt 1973 · S/N 445-73

Back to AD 81-18-04 R2