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.

N20295Adk Flying Club Inc · Ballston Spa, NYBuilt 1972 · S/N 17261168 N20296All Service Solutions Group Corp · Miami, FLBuilt 1977 · S/N 17702655 N20298Hovey Patricia R Trustee · Auxvasse, MOBuilt 1972 · S/N 17261171 N20299Smiley LLC · Clovis, CABuilt 1972 · S/N 17261172 N2029CAnderson Rebecca L · Fort Myers, FLS/N TD-197 N2029LNeff Michael J · Laveen, AZBuilt 1967 · S/N 362 N2029QAshley Steven T · Central City, KYBuilt 1973 · S/N 177RG0429 N2029USmith Thomas A Trustee · Rogersville, ALBuilt 1968 · S/N 11C N202AJEnterprise Aviation Services LLC · Albuquerque, NMBuilt 2007 · S/N 172S10450 N202AKHutchison John N · Big Lake, AKBuilt 1998 · S/N 54 N202AMWalla Walla University · College Place, WABuilt 1975 · S/N 17266213 N202ASQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 287305465 N202BBAkro Atttudes Inc · Lighthouse Point, FLBuilt 2003 · S/N BB001 N202BEKruse Stephan L Jr · Norridgewock, MES/N 1462 N202BKKucharski Bruce J · Pryor, OKBuilt 1976 · S/N 506 N202BRRc Aviation LLC · Ladysmith, WIBuilt 2020 · S/N 2616 N202BWCoastal Defense Inc · Mill Hall, PABuilt 2000 · S/N 20608088 N202BZBraatz Ronald W · Bend, ORBuilt 1976 · S/N 18-7609073 N202CBBrothers Aviation Va LLC · Manassas, VABuilt 1973 · S/N 28-7305360 N202CCJoslyn Larry J · Las Vegas, NVBuilt 1989 · S/N S1421 N202CEBarinowski Perry W · Appling, GAS/N 0001-LAUGHLIN N202CGAvanti LLC · Louisville, KYS/N 5005 N202CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12334 N202CRSt Louis Flying Club Inc · Ellisville, MOBuilt 2003 · S/N 70669 N202CTIsrael Oscar M IV · Sinton, TXS/N R182-00060 N202DGGolovko Daniel M · East Falmouth, MABuilt 1972 · S/N 0083 N202DLLeedham Donald R · Elk River, MNBuilt 2007 · S/N 102956 N202ECRegistered aircraftS/N AA5B-0035 N202EWExecutive Sales And Leasing LLC · Chetek, WIBuilt 1998 · S/N 202-005 N202GESt Amant Mark S · Diamond Bar, CABuilt 1964 · S/N 2896 N202GPRegistered aircraftRegistration pendingBuilt 1998 · S/N 48 N202GTRenfro Michael W · Bethel, AKS/N 4111C N202HSRadford William J · Bumpus Mills, TNBuilt 2005 · S/N CC18-0001 N202JAAdams Toby R · Paris, TXBuilt 1963 · S/N 2570 N202JWHuttunen Leslie M · Long Beach, CAFirst renewal noticeS/N 5332 N202KASkybrothers LLC · Scottsdale, AZBuilt 1974 · S/N 34-7450076 N202LLieberman Alan M Trustee · Pleasanton, CABuilt 2001 · S/N 001 N202LSKsx Aviation Services LLC · San Francisco, CABuilt 2004 · S/N 40.459 N202MBaker Doug E · Tampico, ILBuilt 1996 · S/N 3595 N202MAHatchett William Hal · Edisto Island, SCBuilt 1970 · S/N 28-26740 N202MBRichardson Jane S · San Angelo, TXBuilt 1960 · S/N 18-7305 N202MKMcminn Ronald K · Sequim, WABuilt 1998 · S/N G-2020011 N202MSSutherland Robert D · Fort Walton Beach, FLBuilt 1997 · S/N JS004 N202NEJepsen William R Trustee · Enterprise, ORBuilt 1976 · S/N 17268104 N202NYKingsky Flight Academy LLC · Lakeland, FLBuilt 1980 · S/N 17274198 N202PMIrons Gregory B · Nixa, MOBuilt 1967 · S/N 670440 N202PTHerreman Brian J · Aguila, AZBuilt 2017 · S/N 0016 N202PYEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 17271126 N202QCooper Brian P · Northport, ALS/N 202 N202RDHigh Alpha Aero LLC · Wilmington, DEBuilt 1997 · S/N G2020021

Back to AD 81-18-04 R2