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.

N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283 N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N32990Pray Aviation Inc · Augusta, KSBuilt 1974 · S/N 28-7515285 N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108 N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104 N3299BWamberg Donald D · North Bend, NEBuilt 1954 · S/N 18-3302 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299MJorgensen Duwayne L · Effort, PAS/N 12-2146 N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3299WLowe Russell · Navarre, FLS/N 32-133 N329ABDm Aviation Services LLC · Kennebunk, MEBuilt 2004 · S/N 10578 N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000 N329BCHerring Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2006 · S/N 40190 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N329DPHitchcock Aviation LLC · Twin Falls, IDS/N 18-7609149 N329EPetrocsko David Paul · Scottdale, PABuilt 1999 · S/N 8404-A-684 N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991 N329FPNetwork Spares · Wilmington, DEBuilt 1969 · S/N 18-7421 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N329HPRight Rudder LLC · Halifax, PABuilt 2000 · S/N 3246166 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329JKEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10674 N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574 N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461 N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329 N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512 N329PWHarvey Robert C · Hortonville, WIBuilt 2010 · S/N 40729 N329RPPettis Loren K · Thomaston, GABuilt 2002 · S/N 24828 N329RWHansen Glenn J · Fairfield, CTBuilt 2007 · S/N 3232073 N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443 N329TADelta Pacific Northwest LLC · Anchorage, AKBuilt 1968 · S/N 18-8699 N329WR Moehlectric LLC · Mukilteo, WABuilt 1983 · S/N 329 N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329 N32ABJacobson Neal D · Baker City, ORBuilt 2013 · S/N 81962 N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002 N32AFSchweizer Leslie E · Cayuta, NYBuilt 1983 · S/N 2 N32AHLai LLC · Flowood, MSBuilt 1982 · S/N 1268 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32BMPreston Pietenpol Project LLC · Kalispell, MTBuilt 2017 · S/N M7895 N32BZManganaro John G II · Manvel, TXBuilt 1973 · S/N 32-7300014 N32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034C N32DARalston Mark D · Roseburg, ORBuilt 1977 · S/N 200 N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004 N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692

Back to AD 81-18-04 R2