OpenAirDocs.org
AD 2006-10-21

Registered aircraft · 44,908

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

N107ALAero Tech Services Inc · Lititz, PABuilt 2023 · S/N 172S12989N107AMYoung Mark · Vancouver, WABuilt 1997 · S/N 1385N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202N107AWDust Donald E · London, OHFirst renewal noticeBuilt 1978 · S/N 474-79N107BJJanowsky Bruce G · Lakewood, NYBuilt 2003 · S/N 6054N107CKleinfelter Myles S · Lafayette, INBuilt 2003 · S/N 2058N107ELAa-Aero LLC · Lewes, DEBuilt 2024 · S/N 172S13140N107FRjm Aviation Partners Inc · Naples, FLBuilt 1986 · S/N 599N107FHThree Sixteen LLC · Danbury, TXBuilt 1997 · S/N 2745N107GASwink James E · Flint, TXS/N 2079N107GSSharp Roscoe A · Deer Park, WAS/N 8-0077N107JDDhall Sanjay · Canton, MIBuilt 1991 · S/N DM062N107KPPeterman Keith A · Salinas, CABuilt 1998 · S/N 94-0167N107MECash LLC · Kersey, COS/N 5604N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220N107RCHat Creek Construction & Development Inc · Glennville, GABuilt 1981 · S/N 172RG0807N107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093N107RNHayes Pat · Pittsboro, NCBuilt 2016 · S/N 15-589N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004N107STBennett Edward · Church Hill, MDBuilt 2001 · S/N 260007N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099N107TBRohde Bruce · Fife, WABuilt 2010 · S/N 0540N107TLGeier Jeffrey E · Colfax, WABuilt 2003 · S/N T18208216N107TSSmith Terry G · Liberty Twp, OHBuilt 1982 · S/N 172RG0907N107VJdj Endeavours LLC · Downers Grove, ILBuilt 1986 · S/N 601N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107N107XRQualitair LLC Owner Trustee · MichelstadtBuilt 1999 · S/N 284N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753N1081JSoto Osvaldo · Myersville, MDBuilt 1973 · S/N 81N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346N1083EDavis Gregory P · Olathe, KSBuilt 1977 · S/N 307-77N1083LBenson Mark D · San Diego, CABuilt 1996 · S/N 24-3393N1083TBaer Matthew · New York, NYBuilt 1989 · S/N 27-0023N1084UGranelli Nicholas · Sherman, TXBuilt 1995 · S/N 27-0201N10853St Johns Marine DBA · San Mateo, FLS/N 277854024N1085G3foxtrot LLC · Tucson, AZBuilt 1989 · S/N 27-0009N1085JFloyd Shea · Brownfield, TXBuilt 1973 · S/N 85N1085KSummermatter Richard C · Orchard Park, NYBuilt 1989 · S/N 27-0035N1085SConnell Curtis C · Driggs, IDS/N 27-0036N1085WBas Part Sales LLC · Greeley, COBuilt 1990 · S/N 27-0043N1085ZBeehive Communications Inc · Providence, RIBuilt 1990 · S/N 27-0040N1086JRidgway Stephen · Avon, COBuilt 1973 · S/N 86N1086SDevito David E · Maple Valley, WABuilt 1990 · S/N 27-0044N1086TDutcher Pierpont E · Bend, ORBuilt 1990 · S/N 27-0045N1087CPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10268N1087JKalivretakis Anthony · Southington, CTS/N 87N1087QFairway Auto Clinic LLC · Carlsbad, NMBuilt 1990 · S/N 27-0049
Back to AD 2006-10-21