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.

N365JRBe-A36 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 3389 N365MADip Aviation LLC · Fort Lauderdale, FLBuilt 1999 · S/N 18280582 N365MEEhnisz Craig T · Monterey, CABuilt 2000 · S/N 18280855 N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688 N365NGReid Michael V · Sulphur Springs, TXBuilt 1968 · S/N 28-11124 N365PARotor Leasing LLC · Indianapolis, INBuilt 2017 · S/N 1183 N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033 N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552 N365RWWalter Aviation · Perry, IABuilt 1990 · S/N 903 N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783 N365TGengarelly Robert M · Benson, AZBuilt 2011 · S/N 72419 N365USTecnam US Inc · Sebring, FLBuilt 2021 · S/N 165/US N365WCCrane Douglas F · Ukiah, CABuilt 2002 · S/N 18281170 N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671 N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672 N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673 N3660NJinnette Michael E · Lafayette, COS/N 12-1909 N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764 N3661Mckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1969 · S/N 070 N36615Booth Warren Russell · Doylestown, PABuilt 1978 · S/N 32-7840166 N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286 N3661ARegistered aircraftBuilt 1954 · S/N 22-1921 N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816 N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129 N3661PBradham David T · Kenai, AKBuilt 1955 · S/N 22-3412 N3661QLong Nathan J · Huntsburg, OHS/N MA-251 N3661WPrete Vincent A · Jim Thorpe, PABuilt 1966 · S/N 32-568 N36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74 N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73 N3662CArmi LLC · Nevada, IABuilt 1978 · S/N R18200297 N3662MKerzen Properties LLC · Fayetteville, ARBuilt 1947 · S/N 12-2613 N3662NLarsen Kevin L · Firth, IDBuilt 1947 · S/N 12-1913 N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766 N3662WRocket Three LLC · Sheridan, WYBuilt 2023 · S/N 3662 N3662ZDaniel Dario M · Charlotte, NCBuilt 1960 · S/N 22-7560 N3663Carter Jay M · Mountain Home, ARBuilt 2017 · S/N C75-10112 N3664ARegistration Pending · Taylorsville, KYRegistration pendingBuilt 1954 · S/N 22-1924 N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249 N3664WSuffoletto Gregory · Hamburg, NYBuilt 1966 · S/N 32-572 N3664XLurie Steven C · Delta, ALBuilt 1968 · S/N 314 N3665ADaffron Rodney · Ragland, ALBuilt 1954 · S/N 22-1925 N3665CN3665c LLC · Otsego, MNBuilt 1978 · S/N R18200299 N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817 N3665MErnie Hall Aviation Museum Inc · Warren, OHBuilt 1947 · S/N 12-2530 N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029 N3665PHarness Jesse J · Peoria, AZS/N 18-4621 N3665RDomke Kenneth M · Soldotna, AKBuilt 1954 · S/N 18-4112 N3665WWitham Chris · Cathedral City, CABuilt 1966 · S/N 32-573 N3666CStrauss Kenneth W · Vashon, WABuilt 1978 · S/N R18200300 N3666KVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 22356

Back to AD 81-18-04 R2