Registered aircraft · 81,720

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.

N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199 N2122KKnight Paul · Kawkawlin, MIBuilt 2024 · S/N 2024PK N2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257 N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442 N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039 N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464 N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105 N2123BLovell Mark S · Templeton, CABuilt 1949 · S/N 6550 N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331 N2123KStone Kent H · Franklin, TNBuilt 1979 · S/N 28-7990238 N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034 N2123QMellor James F · Spanish Fork, UTS/N 177RG0523 N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066 N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496 N2123YPalin Investments 3 LLC · Vancouver, WABuilt 2007 · S/N 18281893 N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914 N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916 N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173 N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201 N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259 N2124QBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 177RG0524 N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497 N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230 N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905 N2125QRizzuto Nunzio Stephen · Decatur, ALBuilt 1974 · S/N 177RG0525 N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068 N2125VGallagher Stephen · Delray Beach, FLBuilt 1977 · S/N 32R-7780431 N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499 N21262Aysta Nathan P · Hermantown, MNBuilt 1968 · S/N 130 N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429 N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458 N2126JChristie Ian A H · Limon, COS/N HB007 N2126QDurable Industrial Finishing Co Inc · Tucker, GABuilt 1974 · S/N 177RG0526 N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502 N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273 N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920 N21276Schrager Daniel L Trustee · Concord, MABuilt 2003 · S/N 172S9433 N21279Kerry Air LLC · Wilmington, DEBuilt 2016 · S/N 2448 N2127CRowsey Andrew M · Corinth, MSBuilt 1959 · S/N 7GC-50 N2127DMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 447995131 N2127PDerbenwick Gary F · Colorado Springs, COBuilt 1979 · S/N 28-7990291 N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465 N2127TGeiger Glenn M · Cincinnati, OHBuilt 1971 · S/N 28R-7135070 N2128Boone T Daniel · Avon, ILBuilt 1968 · S/N 475 N21281Horne Randall W · Millington, TNBuilt 1972 · S/N 18261535 N21288Cunningham Campers Inc DBA · Clarksville, INBuilt 1978 · S/N 28-7990040 N21289High Flight Academy LLC · Allison Park, PABuilt 1974 · S/N 17263923 N2128ANull Clifford M · Punxsutawney, PABuilt 1952 · S/N 22-570

Back to AD 81-18-04 R2