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.

N3645WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-549 N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302 N3646063nl LLC · Willmar, MNBuilt 1981 · S/N 62P09008165029 N3646HAdams Toby R · Paris, TXBuilt 1980 · S/N 6008568161245 N3646KParrish Doug · Monument, COBuilt 1981 · S/N 61P08578163453 N3646PMr Group · Rapid City, SDS/N 6108598162155 N3646WWap Air LLC · Newburgh, INBuilt 1966 · S/N 32-550 N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518 N3647KRayman Bethany A · Salem, SDS/N 28-23666 N3647MMeier Wayne N · Eagan, MNBuilt 1947 · S/N 12-2600 N3647PHubbard Robert Thomas · Atlanta, GABuilt 1955 · S/N 22-3398 N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744 N3647WNichols Robert H Jr · Normandy, TNBuilt 1966 · S/N 32-551 N3648BMcgill Aviation Inc · Greensboro, GABuilt 1981 · S/N 62P08668165006 N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667 N3648MWatercub LLC · Minnetonka, MNBuilt 1947 · S/N 12-2605 N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233 N3648ZMow The Sky LLC · Midway, UTBuilt 1960 · S/N 22-7545 N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519 N3649MScheele Kevin M · Eagle River, AKBuilt 1947 · S/N 12-2604 N3649PHelmer Daniel W · Eagle, AKBuilt 1955 · S/N 22-3400 N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234 N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746 N3649WTurbo Six LLC · Wilmington, DEBuilt 1966 · S/N 32-554 N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990 N364BTFlying B Land And Timber Co LLC · Pineville, LABuilt 2013 · S/N 25621 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364DRegistered aircraftBuilt 2014 · S/N 172S11373 N364DCClowes Delbert · Shafter, CABuilt 2014 · S/N 75-7639-001 N364DMMoon David A · Valkaria, FLS/N 1001 N364FSN927nw LLC · Watchung, NJBuilt 2000 · S/N 23065C N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N364GWHdh Aircraft Leasing LLC · Carrollton, TXBuilt 2003 · S/N 172S9364 N364HKoberg Lance L · Dallas, GABuilt 1974 · S/N 364 N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364 N364MCLesser Antilles Corp Trustee · Wilmington, DEBuilt 1973 · S/N 32-7300039 N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246 N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654 N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364WMMoore Bruce W · Aledo, TXBuilt 2014 · S/N 81899 N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645 N3650MJarvis Ty N · Kinnear, WYBuilt 1947 · S/N 12-2603 N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747 N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520 N3651AAir Cowboy LLC · Roca, NES/N 22-1911 N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295 N3651MAtlanta Airmotive Inc · Franklin, NCBuilt 1947 · S/N 12-2601 N3651NGreer Guy A · Wasilla, AKS/N 12-1902 N3651WTraxler Christopher V · Russia, OHBuilt 1966 · S/N 32-556 N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548

Back to AD 81-18-04 R2