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.

N5331YHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496163 N5331ZDaye Jeffrey E · Salisbury, NCBuilt 1962 · S/N 22-9038 N53323Chester Charter Inc · Chester, CTBuilt 1981 · S/N 17274720 N5332LWings Over L A Aviation LLC · West Hills, CAS/N 28-4636 N5332PLarsen Joseph · Pittsburgh, PABuilt 1958 · S/N 24-376 N5332SNimmons Johnny · Brookshire, TXBuilt 1970 · S/N 28-26926 N5332VMinuteman Aviation Inc · Missoula, MTBuilt 2003 · S/N 172S9341 N5332ZGulley Mark E · Guntersville, ALBuilt 1961 · S/N 22-9041 N5333HMcchristian Jerome M · Granbury, TXS/N 16-139 N5333LCentral Indiana Aviation Mission Inc · Cicero, INBuilt 1968 · S/N 28-4637 N5333MWeaver William Cookman III · Fayetteville, NCBuilt 1977 · S/N 28-7816140 N5333PMilligan David B · Russellville, ARBuilt 1958 · S/N 24-378 N5333WHeidelberg Haley · Huntington, TXBuilt 1962 · S/N 28-390 N5333ZRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1961 · S/N 22-9042 N53340N53340 LLC · Boynton Beach, FLBuilt 2003 · S/N 17281160 N5334DProfessionals Aviation Co Inc · Millersburg, OHBuilt 1979 · S/N 17272523 N5334HThirty-Four Hotel · Houlton, MEBuilt 1975 · S/N 17265405 N5334LJwac Aviation LLC · Cullman, ALBuilt 1968 · S/N 28-4639 N5334SFischer Howard W Jr · Boydton, VABuilt 1970 · S/N 28-26924 N5334UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281156 N5334WPeterson Eric S · North Logan, UTBuilt 1962 · S/N 28-391 N5334ZUeeck Robert D · Minnetonka, MNS/N 22-9044 N53351Clover Park Technical College · Lakewood, WABuilt 1981 · S/N 17274725 N5335DPeltz Matthew J · Ringsted, IABuilt 1979 · S/N 17272524 N5335FEasterby Daniel · Big Bear Lake, CABuilt 1976 · S/N 28-7790090 N5335GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281158 N5335JFirst Eclipse Limited · Richmond, VABuilt 2003 · S/N 172S9347 N5335PFlying Vikings Inc · Hayward, CABuilt 1981 · S/N 15284919 N5335SSpartan Education LLC · Tulsa, OKBuilt 2003 · S/N 172S9349 N5335WPost 8 Flight Ops Inc · Topeka, KSBuilt 1962 · S/N 28-392 N5335ZGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 22-9045 N53361Adb Aircraft LLC · Viera, FLBuilt 1981 · S/N 17274727 N5336DFerguson Bart M · Argyle, TXBuilt 1979 · S/N 17272525 N5336KSharpes Daniel G · Albuquerque, NMBuilt 1980 · S/N 17274069 N53371Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274733 N53372Clover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281170 N5337FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790092 N5337HOder Kenneth L · Taylorsville, KYBuilt 1949 · S/N 16-143 N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296 N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920 N5337SAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 2001 · S/N 2843479 N5337TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250249 N5337ZBrown Estates Aviation LLC · Fresno, CABuilt 1961 · S/N 22-9047 N53380Haltom Gary D · Alva, OKS/N 15283540 N53387Reifsnyder Daniel S · Lewistown, PABuilt 1981 · S/N 17274738 N5338FParker Gary L · Metamora, MIBuilt 1976 · S/N 28R-7635452 N5338LHaynes Robert · Friendswood, TXBuilt 1968 · S/N 28-4643 N5338NRaritan Valley Flying School · Princeton, NJBuilt 2003 · S/N 172S9358 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841

Back to AD 81-18-04 R2