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.

N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984 N13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1970 · S/N 27-4581 N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985 N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409 N1397CDerr Rodney W · Frackville, PAS/N 22-1154 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398HMiller Debra L · Anchorage, AKS/N 15AC-449 N1398JPrivedenynk Sergey · Springfield, MABuilt 1975 · S/N 398 N1398PWolbert Valerie M · Canton, GABuilt 1956 · S/N 23-449 N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798 N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150 N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139AAMeloan Andrew Newton · St Helena Is, SCBuilt 2000 · S/N 04980085 N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92 N139AGSchool Board Of Seminole Co Florida · Sanford, FLFirst renewal noticeBuilt 1981 · S/N 0131 N139BCTrombley Steven T · Worland, WYBuilt 2008 · S/N 506-2008 N139BKInternational Air Service Inc Trustee · Carson City, NVBuilt 1981 · S/N 139 N139BSDonato James J · Hawthorne, FLBuilt 2000 · S/N 11152 N139CPLai LLC · Pearl, MSS/N 18073C N139DBWolfe LLC · Rogers, TXS/N 27-4611 N139DMMurillo Raymond A · Pico Rivera, CABuilt 1969 · S/N 28R-35262 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532 N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174 N139GMclearran Jr William C · Oro Valley, AZBuilt 1979 · S/N 375 N139MWhitney Richard T · Steamboat Springs, COBuilt 2015 · S/N 3239 N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541 N139NLowery William D · Geneva, FLBuilt 2020 · S/N 001 N139PCSavage David Edward · American Falls, IDBuilt 2002 · S/N 1339-2002 N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614 N139RKKinkade Jonathan A · Tucson, AZBuilt 2010 · S/N 90929 N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195 N139SFCaracciolo Tristano · Dayton, NVBuilt 1994 · S/N 688 N139SNMccullough Jacob D · Lockhart, TXBuilt 1965 · S/N 28-2184 N139TFWithrotor Aviation Inc · Lakeview, ORBuilt 2009 · S/N 82465 N139TWMcghee James Allen · Houston, TXBuilt 2002 · S/N 172S9139 N139UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11488 N13AHCasady Joseph P · Buckley, WABuilt 1995 · S/N 1334 N13AVGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-028 N13BDLinenfelser Charles D · Hardy, VABuilt 1987 · S/N 1357 N13BFWygant Steven J · Copper Center, AKBuilt 2008 · S/N 3021 N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532 N13BSSteele Roger H · Cedar City, UTS/N 1259 N13BVGarrett Steven R · Pittsburg, TXBuilt 2003 · S/N 10013

Back to AD 81-18-04 R2