OpenAirDocs.org
AD 81-18-04 R2

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
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.

N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577N1506JHumbles Frank Forrest · Charleston, SCBuilt 1976 · S/N 13003N1506PStevens John P · Hernando, FLBuilt 1954 · S/N 22-2370N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028N1507PWagner Rickey J · Stacy, MNBuilt 1954 · S/N 22-2372N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018N1508ARegistered aircraftS/N 20-694N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030N1508TWalker Jereme · Durham, NCBuilt 1972 · S/N 28R-7235308N1509FDragonfly Helicopter Service Ltd · North Dighton, MABuilt 2005 · S/N 0213N1509RHarris Luke · Hampstead, NCS/N AA1B0659N150AAReed Aviation Inc · Iota, LABuilt 1972 · S/N AA1A-0394N150ABPurple Sage Aero LLC · Leonardtown, MDBuilt 1994 · S/N 04940068N150AHRegistration Pending · Upland, CARegistration pendingBuilt 1993 · S/N 03930058N150AKCamp Ted A · Williamson, GAS/N 04940071N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074N150AQQualitair LLC Trustee · MichelstadtS/N 04940067N150ATRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1994 · S/N 04940069N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073N150AZPython Financial LLC · Kalispell, MTS/N CH400N150BRegistered aircraftRegistration pendingBuilt 2002 · S/N 1199N150BJDakota Air LLC · Delray Beach, FLBuilt 1983 · S/N 28-8311013N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857N150CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283268N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064N150CPNelson Chris L · Yankton, SDBuilt 2018 · S/N 40919N150CWCleveland William L · Lander, WYS/N 18-4329N150DHHollenbaugh Roger Dean · Jamestown, COBuilt 1987 · S/N 240N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554N150GHOtto Gregory A · Plano, TXBuilt 1997 · S/N DM0150N150HCJones Luis · Las Vegas, NVS/N A1500725N150HPGrimes Brian T · Kingman, AZS/N 001N150JPSale Reported · King Salmon, AKSale reportedBuilt 2010 · S/N 001N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678N150LELeading Edge Flight Academy LLC · Bend, ORBuilt 2000 · S/N 3150N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193N150LMBrake Michael S Trustee · Granbury, TXBuilt 2007 · S/N 72529
Back to AD 81-18-04 R2