Registered aircraft · 72,001

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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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.

N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1504XVerge Aeronautics LLC · Charlotte, NCBuilt 1975 · S/N 28R-7535301 N15050Houston William W · Baltimore, MDBuilt 1972 · S/N 28-7225569 N15057Bad Dog Aviation · Meridianville, ALBuilt 1972 · S/N 28-7225572 N1505XFarrell Donald A · Owasso, OKBuilt 1975 · S/N 28R-7535302 N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005 N15066Cherokee Aviation Group LLC · Alpharetta, GABuilt 1972 · S/N 28-7225577 N1506JHumbles Frank Forrest · Charleston, SCBuilt 1976 · S/N 13003 N1506TWaldrep Zoey V · Tampa, FLS/N 28-7225538 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N15079Rea Robert III · Bumpass, VABuilt 1972 · S/N 28-7225585 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507TAero Care Inc · Orange, MABuilt 1972 · S/N 28-7205310 N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018 N1508JLiwag Reynaldo T Jr · Niagara Falls, NYBuilt 1967 · S/N 28-23901 N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030 N1509FDragonfly Helicopter Service Ltd · North Dighton, MABuilt 2005 · S/N 0213 N150AAReed Aviation Inc · Iota, LABuilt 1972 · S/N AA1A-0394 N150ABPurple Sage Aero LLC · Leonardtown, MDBuilt 1994 · S/N 04940068 N150AHRegistration Pending · Upland, CARegistration pendingBuilt 1993 · S/N 03930058 N150AKCamp Ted A · Williamson, GAS/N 04940071 N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074 N150AQQualitair LLC Trustee · MichelstadtS/N 04940067 N150ATRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1994 · S/N 04940069 N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073 N150AZPython Financial LLC · Kalispell, MTS/N CH400 N150BRegistered aircraftRegistration pendingBuilt 2002 · S/N 1199 N150BJDakota Air LLC · Delray Beach, FLBuilt 1983 · S/N 28-8311013 N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857 N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064 N150CPNelson Chris L · Yankton, SDBuilt 2018 · S/N 40919 N150CWCleveland William L · Lander, WYS/N 18-4329 N150DHHollenbaugh Roger Dean · Jamestown, COBuilt 1987 · S/N 240 N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087 N150FCHart John Jr · Vallejo, CABuilt 1992 · S/N 27-0139 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150GHOtto Gregory A · Plano, TXBuilt 1997 · S/N DM0150 N150HCJones Luis · Las Vegas, NVS/N A1500725 N150HPGrimes Brian T · Kingman, AZS/N 001 N150JPSale Reported · King Salmon, AKSale reportedBuilt 2010 · S/N 001 N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678 N150LELeading Edge Flight Academy LLC · Bend, ORBuilt 2000 · S/N 3150 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N150LMBrake Michael S Trustee · Granbury, TXBuilt 2007 · S/N 72529 N150MFRevolution Robotics Inc · Corvallis, ORBuilt 2001 · S/N 0015 N150MMAdams Jon S · Whitmore Lake, MIBuilt 1984 · S/N M-1-1115 N150NDClear Skies Avionics Inc · Clearwater, FLS/N 1186 N150NHPalmer Ronald Everett Trustee · Hopkinton, NHBuilt 1983 · S/N 18-8309012 N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23 N150PTAlchin Aviation LLC · Durand, MIBuilt 2005 · S/N 40.468

Back to AD 87-10-06 R1