Registered aircraft · 81,718

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.

N111MEElliott Enterprises Group LLC · Wilmington, DEBuilt 2010 · S/N 073 N111MJJohn D Chinchen Md Pa · Mountain Home, ARBuilt 1968 · S/N 680147 N111MLArcara Sebastiano · Bridgeton, NJBuilt 1977 · S/N 1 N111MVVodon Mark A · Ventura, CABuilt 2004 · S/N 21869 N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092 N111NFNakonieczny David · The Colony, TXBuilt 2024 · S/N 5148 N111NPBlackfoot Aviation LLC · Bozeman, MTS/N 28-3046 N111NRMartin Roy Keith · Ocala, FLBuilt 1998 · S/N 111001 N111NWKnell LLC · Casper, WYBuilt 1976 · S/N 32R7680499 N111PBRegistered aircraftBuilt 1997 · S/N 2705 N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929 N111PPPerritt Ricky D · Milton, FLS/N AM-3 N111PSAjeac Inc · Fairview, PABuilt 2019 · S/N SUV111 N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874 N111SA111sa LLC · Greeley, COBuilt 1972 · S/N 17260937 N111SLKaehlert Lottie DBA · Rifle, COS/N 24-2532 N111TJKrueger Steven A · Merrill, WIBuilt 2000 · S/N 001 N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828 N111TQEngbring Paul · Telluride, COBuilt 1993 · S/N 1243 N111UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3750 N111UYGonzales Jon · Prairieville, LABuilt 2003 · S/N 2227 N111VXParmar Jaywant Philip · San Luis Obispo, CABuilt 2003 · S/N 3FG031 N111WMMoore Forrest · Liberty Hill, TXBuilt 1978 · S/N 28R-7837159 N111XFBender Thomas G · Albuquerque, NMBuilt 1997 · S/N 24474 N111XJCc Bar Ranch LLC · Texarkana, TXBuilt 1998 · S/N 1429 N111XRRose Carl William Jr · North Fort Myers, FLBuilt 1979 · S/N 2204 N111YZBuell Travis W · Harper, TXBuilt 1990 · S/N 1622 N111ZYSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276611 N11201Moment Stuart L · Urbana, ILBuilt 1976 · S/N 24-0058 N1120LGotschall John F · Silverdale, WABuilt 1963 · S/N 282 N1120UNistler Matthew J · Three Forks, MTBuilt 1959 · S/N 186723 N1120ZWhite Wing Air LLC · Garden Grove, CAS/N 172S10313 N1121CSupercub LLC · Ormond Beach, FLBuilt 1953 · S/N 182221 N1121LSunset Hill Ventures LLC · Menomonie, WIS/N 283 N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429 N1121XCrosscheck Ftc LLC · Greeneville, TNBuilt 1975 · S/N 28-7515316 N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329 N1122ACox Abraham · Key West, FLBuilt 1968 · S/N 28-25081 N1122GGroelz Philip B · Canby, ORBuilt 2017 · S/N 90772 N1122LMake A Splash Aviation LLC · Brodheadsville, PAS/N 704 N1122MMeyer Jeremie D · Oconto Falls, WIBuilt 2018 · S/N JDM-1 N1122TAircraft Solutions Group LLC · Englewood, COBuilt 2019 · S/N 172S12416 N11235Mcdonald Air LLC · Floyds Knobs, INBuilt 1984 · S/N 24-1471 N1123AWiplinger Robert D · Inver Grove, MNBuilt 1951 · S/N 18-716 N1123BBonsall Sandie W · Fowler, KSBuilt 2012 · S/N 7080 N1123CTuschhoff Stetson Rd · Jackson, MOBuilt 1953 · S/N 22-960 N1123EVonimhof Rudolph F · Anchorage, AKBuilt 1979 · S/N 18-7909062 N1123FUrsus Air Services · Anchorage, AKBuilt 2002 · S/N 20608173 N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133 N1123WThiel Jonathan Ronald · Billings, MTS/N 28-771

Back to AD 81-18-04 R2