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

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.

N3356WFive Six Whiskey LLC · Plainfield, INBuilt 1965 · S/N 32-200 N33575Nationwide Aviation LLC · Hudson Oaks, TXS/N 28-7515347 N3357KNewman Steve M · Portland, ORS/N 1350 N3357MSmith James R · Toney, ALBuilt 1947 · S/N 12-2049 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297 N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165 N3359BWoodman Dwight C · Windham, MES/N 18-3313 N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N3359WMcmaster James R II · Bath, PABuilt 1965 · S/N 32-205 N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367 N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085 N335BWThorp T-18 Ri LLC · Foster, RIFirst renewal noticeBuilt 1995 · S/N 720 N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372 N335DSWhitaker Martin · Portland, MEBuilt 2008 · S/N 10702008 N335ERunia Allan D Trustee · Gold Hill, ORBuilt 1992 · S/N 246 N335FDRoy Martin P · Chehalis, WABuilt 1989 · S/N 335 N335HCOtis Stephen H · Mcalester, OKBuilt 2006 · S/N 022 N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879 N335MDHamstra Armen Nofer · Saratoga, CABuilt 1982 · S/N 32-8206036 N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158 N335RKGallant David A · Hartsel, COBuilt 2013 · S/N 001 N335RLWeeks James S · Boynton Beach, FLBuilt 2002 · S/N 23254 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N335RVCroce Matthew A · Palo Alto, CABuilt 2008 · S/N 80335 N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495 N335TBpu Enterprises LLC · Schuylkill Haven, PABuilt 2016 · S/N 2452 N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464 N335WMMilbauer Wayne N · Fuquay Varina, NCBuilt 2024 · S/N 112-215/216-1088 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N3360PThomas Lyndon J · Wasilla, AKBuilt 1950 · S/N 18-391 N3360VJustis Jeff · Oxford, MSBuilt 2022 · S/N 42029 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3361ANimmick Robert A · Three Forks, MTFirst renewal noticeS/N 20-1067 N3361BSmith Marcus H · Roxboro, NCS/N 22-2166 N3361MTrinkle Chris · Heyburn, IDS/N 12-2240 N3361TPew Aaron · Mesa, AZS/N 17700661 N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662 N33631First Class Emergency Vehicles LLC · Monroe, NCBuilt 1975 · S/N 32-7500026 N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213 N3363A7ac Club Inc · Clearwater, FLBuilt 1953 · S/N 22-1665 N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219

Back to AD 81-18-04 R2