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.

N499DPFarrington John R · Cedar Park, TXBuilt 2010 · S/N 2001-2010 N499DRWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 172S9167 N499EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11604 N499ETQualitair LLC Owner Trustee · MichesltadtBuilt 2006 · S/N 18281808 N499FLSchrock Derrick L · Jesup, GABuilt 1971 · S/N 28-7125316 N499KWRidgeline Assets LLC · Wilmington, DEBuilt 2000 · S/N 172S8430 N499LCLimocopter LLC · Orlando, FLBuilt 2023 · S/N 2732 N499LTTurk Lance G · Omak, WABuilt 1982 · S/N 499 N499TGCrest Aviation LLC · Broomfield, COS/N 28-7425318 N499UVUtah Valley University · Orem, UTBuilt 2019 · S/N 4496454 N499WLee Chris · Granger, INBuilt 2004 · S/N 40.423 N499WBStenson Ryan · Newton, NHS/N 07001 N499WSColeman Justin C · Denver, COBuilt 2009 · S/N 90002 N49ABFay William E · Washougal, WAS/N 13066 N49AKIllig Peter E · Anchorage, AKFirst renewal noticeBuilt 1956 · S/N 22-3814 N49ATAirgo Inc · Centralia, ILBuilt 1981 · S/N 44-8107041 N49AVHetrick Buzz · Overland Park, KSS/N M11-251 N49CFWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18-7609110 N49CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17262238 N49CMS & B Aviation LLC · Incline Village, NVBuilt 1998 · S/N 357 N49CNVenture Air LLC · Leonard, NDBuilt 1999 · S/N 0554 N49CSDoherty Sean M · Collinsville, OKBuilt 1980 · S/N SAWKA 0001 N49DBBabcock David A · Puyallup, WABuilt 1995 · S/N 3389 N49DCSpencer William D · Martinsville, VAS/N 01 N49DPPrince David A · Homer, AKBuilt 1975 · S/N 18-7509035 N49DRRussell Thomas P · Milo, MEBuilt 2001 · S/N 2001-1 N49DTClark Coy A · Raeford, NCBuilt 1957 · S/N 7FC-117 N49DWRamsey Keith W · Morrison, TNBuilt 1987 · S/N 463 N49EELessley Aviation LLC · Carrollton, MSBuilt 1998 · S/N 1239-98 N49ESToby Louis J · Waterford, MIS/N 319 N49EXReinhard Metz · Wheaton, ILBuilt 1997 · S/N 01 N49EZMagner Gregory R · Lakeville, MABuilt 2005 · S/N 2001 N49GDMichel Kris · Shelter Cove, CABuilt 1983 · S/N RS-10 N49GTKugielsky Benjamin W · Newtown, CTBuilt 1975 · S/N AA5B-0116 N49GWWymer Gerald A · Edgewood, NMBuilt 2011 · S/N 239 N49HCHoffman Earl R Jr · Wildwood, MOBuilt 2023 · S/N 3421 N49HPFour Niner Hotel Papa LLC · Grosse Pointe Park, MIBuilt 2007 · S/N 2381 N49HSSherburne Asher J · Redlands, CABuilt 2006 · S/N 03-123 N49HYMusbach James I · Pacific Grove, CABuilt 2002 · S/N 2212 N49JAGolden Age Air Museum · Bethel, PABuilt 1999 · S/N 174 N49JBTilley Robert E · Albany, GABuilt 2013 · S/N 049 N49JFBearce Jonathan R · Rosamond, CABuilt 1997 · S/N DMO-051 N49JKWilliams Casey D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3329 N49JMScott L Geller Co · Fort Myers, FLBuilt 1989 · S/N M1 N49JRBitikofer Brent E · Kansas City, KSBuilt 1974 · S/N JE1 N49KMAvance Aviaiton LLC · Burlington, MABuilt 1969 · S/N 28-5729 N49KSSchlageter Keith A · Evansville, INBuilt 2001 · S/N 80650 N49LCBlue Water Aviation Inc · Jupiter, FLBuilt 2003 · S/N PA18-0603 N49MBCrane John A · Gig Harbor, WAS/N 101MO N49MGCastle Aviation Inc · North Canton, OHBuilt 1979 · S/N 6006347961201

Back to AD 81-18-04 R2