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.

N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083 N489PFFleming Peter A · Santa Clarita, CABuilt 2014 · S/N 2813 N489RSViage LLC · Boston, MABuilt 2004 · S/N 40.379 N489RVBoyter Wayne · Winston, ORBuilt 2008 · S/N 21275 N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024 N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328 N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064 N48BKKrebs Brian G · Hartland, WIBuilt 2012 · S/N 82136 N48BRField Christopher R · Kingston, TNBuilt 2009 · S/N 90951 N48CDSky Helicopters Inc · Desoto, TXBuilt 2016 · S/N 30006 N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163 N48CLSharp Wade L · Asheville, NCS/N 21184 N48DFFuhrman Dennis M Trustee · Independence, ORBuilt 2020 · S/N 41653 N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386 N48EAHillbilly Air LLC · Wilmington, DEBuilt 2010 · S/N 3114 N48EBEbgineering Inc · Ocklawaha, FLBuilt 2003 · S/N 70755 N48EFVista Air Inc · Pacoima, CABuilt 2004 · S/N 172S9629 N48ELRegistration Pending · Livermore, CARegistration pendingBuilt 2004 · S/N 1363 N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906 N48EVRichardson Mark E · Altus, OKBuilt 2007 · S/N 823 N48FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12875 N48FHG-Stf LLC · Midland, TXBuilt 1979 · S/N R18201018 N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049 N48GKAnderson Kirby L · Mcveytown, PABuilt 1980 · S/N 48 N48GWMajerle Steven A · Big Lake, AKBuilt 1965 · S/N CS-1 N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975 N48HGJahn Glenn R · Torrance, CABuilt 2005 · S/N 70449 N48HTTurner Robert E · Castro Valley, CABuilt 2011 · S/N 40745 N48HUMelair 6 LLC · Easton, MDBuilt 2024 · S/N 3438 N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196 N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312 N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110 N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693 N48JWLee William L · Jonesborough, TNBuilt 1989 · S/N 2 N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26 N48KSHolcomb Garry M · Point, TXS/N PTS101 N48MBCaddell Charles Thomas · Wadesboro, NCBuilt 2000 · S/N 60059 N48MMDierks Herman D · Round Rock, TXBuilt 1967 · S/N RCM67 N48MRCasey Mike P · Whitefish, MTBuilt 1947 · S/N 12-2583 N48NGSterling Air Inc · Little Rock, ARBuilt 1951 · S/N WD365 N48PKWoodward Daniel S · Springville, UTS/N 5382 N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533 N48RDMiller Montgomery A · Carmel, INBuilt 1982 · S/N 1 N48RGBlueskies LLC · Smyrna, TNBuilt 2023 · S/N 172S12953 N48RPClark Mitchell J · Parker, COBuilt 1978 · S/N 658-H N48SSiragusa Pamela L · Cypress, TXBuilt 1958 · S/N TD-40 N48SJJohnston Stephen P · Hawley, MNBuilt 1948 · S/N 1466 N48SUGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285186 N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297 N48VZPrecision Jet Service Inc · Stuart, FLBuilt 1973 · S/N 32-7300044

Back to AD 81-18-04 R2