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.

N248PVVasquez Pablo Javier Jr · El Dorado Hills, CABuilt 1991 · S/N 243221 N248SFEl Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13443 N248SWHicks James P · Franklin, OHBuilt 2013 · S/N 688 N248TGiannonatti Lance A · Ludlow, SDBuilt 1953 · S/N 18-2362 N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613 N248TTLohrman Lonny A · Wichita, KSBuilt 2018 · S/N 25408 N24905Cochran David · Richmond, KSBuilt 1939 · S/N 3528 N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445 N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254 N2490VPiper Aircraft Inc · Vero Beach, FLBuilt 1982 · S/N 38-82A0068 N2490YSheboygan Flight Plane III LLC · Sheboygan, WIBuilt 1985 · S/N 28-8590077 N24914Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0017 N2491ACampbell Aviation Inc · Dutton, MTBuilt 1952 · S/N 18-1962 N2491CPearlman Lawrence A · South Boston, VABuilt 1978 · S/N 38-79A0203 N2491FCarlson Dann S · Kailua, HIBuilt 1979 · S/N 38-79A0477 N2491MPope Geoffrey M · Bishop, CABuilt 1947 · S/N 12-1698 N2491TLichtman Bruce A · Stafford, VABuilt 1971 · S/N 28-7225078 N24920Springett Justin · Boulder, COS/N 15280450 N24928Hancock Carl M · Glendale, AZS/N 3543 N2492MSchaaf Terry L · Bowman, NDBuilt 1947 · S/N 12-1699 N2492TOmni Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7205060 N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456 N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457 N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459 N2493MDriver Kegan Thomas · Billings, MTS/N 12-1561 N24947Aty Aviation Inc · Watertown, SDS/N 15280464 N2494AOtto Justin · Lakeland, TNBuilt 1952 · S/N 18-1961 N2494BMunger Steven D · Mifflintown, PABuilt 1978 · S/N 38-79A0092 N2494MJbbs Enterprises Inc · Middletown, DEBuilt 1977 · S/N 28-7890255 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467 N2495APhillipine Matthew · Bonita Springs, FLBuilt 1978 · S/N 38-78A0715 N2495DGutierrez Roberto R Jr · Edinburg, TXBuilt 1978 · S/N 38-79A0333 N2495MPark Brian D · Springville, UTBuilt 1977 · S/N 28R-7837090 N2495TAvia Flight Academy LLC · Stratford, CTBuilt 1971 · S/N 28-7205061 N2496ASibille Keith C · Griffin, GABuilt 1952 · S/N 18-1963 N2496MMorgan Jay · Fort Mill, SCBuilt 1977 · S/N 28R-7837091 N2496PTri M LLC · Nikiski, AKS/N 18-4305 N24978Trees Thomas A · Lacey, WABuilt 1979 · S/N 18-7909196 N2497ARobertson Roy A · Anchorage, AKBuilt 1952 · S/N 18-1967 N2497BHoward Eldon J · Lewiston, IDBuilt 1980 · S/N 18-8109009 N2497EBenham Aviation LLC · Enid, OKBuilt 1978 · S/N 17271303 N2497PWright William B Jr · Deeth, NVBuilt 1955 · S/N 18-4306 N2497RMarkley John T · Center Harbor, NHBuilt 1969 · S/N 28-5636 N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490 N24986Charlston Michael M · Haleiwa, HIBuilt 1977 · S/N 15280495 N2498DGenzlinger Chad A · Foresthill, CABuilt 1978 · S/N 38-79A0334 N2498PBarnes Stephen Ray · Cordova, AKBuilt 1955 · S/N 18-4307 N24995Stiles Robert K · Lynden, WABuilt 1977 · S/N 15280502 N24998Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280503

Back to AD 81-18-04 R2