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.

N508XCHirst Jeremy · Solana Beach, CABuilt 2016 · S/N CC19-0005 N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232 N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705 N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34 N5090QTakai Hiroyasu · San Jose, CABuilt 1981 · S/N 15285071 N5090SSturm Neal M · Randolph, NJBuilt 1971 · S/N 28R-7135091 N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346 N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99 N5090XOwen Suzanne L · Eagle Point, ORBuilt 1969 · S/N 655 N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233 N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706 N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100 N5091SLancellotti Peter · Knoxville, TNBuilt 1980 · S/N R18201503 N5091TBlank Philip J · Pleasanton, CABuilt 1981 · S/N R18201814 N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100 N5091XMorois Jake D · Green Bay, WIBuilt 1969 · S/N 656 N50924Robinson Mark V · Vacaville, CAS/N 318 N50926Registered aircraftBuilt 1992 · S/N 002 N5092EKaye Russell G · New Fairfield, CTBuilt 1978 · S/N 17271707 N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891 N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347 N5092XCurcio Joseph A Jr · Granite Bay, CAS/N 657 N50935Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274365 N50938J & J Ag Products Inc · Clewiston, FLBuilt 2001 · S/N 3246184 N5093EBohmer Carla M · Tulsa, OKS/N 17271708 N5093KL A M Capital Management LLC · Sheridan, WYBuilt 1980 · S/N 17273964 N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102 N5093QRiya Aviation LLC · Tracy, CABuilt 1981 · S/N 15285073 N5093RSkyhawks Inc · Montoursville, PABuilt 1974 · S/N 17263331 N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301 N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378 N5093ZSelby Gerald A · Sand Springs, OKBuilt 1961 · S/N 22-8727 N50941Labrucherie Peter E · El Centro, CAS/N 17264216 N50944Munoz Jacqueline T · Huntsville, ALS/N 17264217 N50947Bend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17264218 N5094BSmith Glenn · Orange Park, FLBuilt 2007 · S/N 001 N5094LGorge Winds Aviation Inc · Fairview, ORBuilt 1980 · S/N 15284260 N5094RHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N 17263332 N5094SBoraam Aviation Inc · Prospect Heights, ILBuilt 1971 · S/N 28R-7135094 N5094TKrass Roman · West Hills, CAS/N M-1137 N5094ZDugan Garry P · Manvel, NDBuilt 1961 · S/N 22-8728 N5095PGyrfalcon Air Holdings LLC · Boise, IDS/N 15284875 N5095RTraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17263333 N5095TColter Duane E · Plainfield, INBuilt 1968 · S/N M-1138 N5095WBailey Bruce B · Dublin, VABuilt 1961 · S/N 28-107 N50961Flight Skills LLC · Raleigh, NCBuilt 1977 · S/N 177RG1136 N50967Sellers Raymond L · Trussville, ALS/N 17264221 N5096DSchrader Thomas R · Anchorage, AKBuilt 2008 · S/N 01 N5096GRiya Aviation LLC · Tracy, CABuilt 1979 · S/N 17273545 N5096HMyhre Norman G · Hixton, WIBuilt 1975 · S/N 17265339

Back to AD 81-18-04 R2