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.

N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991N13710Registered aircraftBuilt 1976 · S/N 17702456N1371JSajko Gary · Chesapeake, VABuilt 1975 · S/N 371N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654N1373ZHoitt Edward D Jr · Deerfield, NHBuilt 1961 · S/N TD-479N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467N1374JE2a Distributors Inc · Monroe, GABuilt 1975 · S/N 374N1374WWade Deborah D · Mineral Wells, TXBuilt 1963 · S/N 2655N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715N1375JRegistration Pending · South Burlington, VTRegistration pending, pending cancellationBuilt 1975 · S/N 375N1375WAndrews Kevin M · Hermitage, TNBuilt 1963 · S/N 2656N13760Chiniewicz Michael · The Colony, TXBuilt 1969 · S/N 27-4409N1376JHogue Robert D · Rockwall, TXBuilt 1975 · S/N 376N1376WMarling Russell Cole · Highlands, NCS/N 2657N1377JDurrah Anthony E · Charlotte, NCBuilt 1975 · S/N 377N1377SUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2005 · S/N 172S9840N1378JAeronautics Inc · Vero Beach, FLBuilt 1983 · S/N 10N1379TGordon William E · Summit, NJBuilt 1972 · S/N 28-7205290N137ACHare Michael Aubrey · Foley, ALBuilt 1992 · S/N 676-92N137ASFlight Leasing Corp · Wilmington, DES/N ME-72N137BCJrnd Corp · Lewes, DEBuilt 2003 · S/N 2843584N137CCMore Right Rudder LLC · Sioux City, IABuilt 1977 · S/N 28R-7737065N137CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13486N137DBMichel Daniel T · Sterling, AKBuilt 2021 · S/N 0001N137DCThompson Joseph D · Alliance, NEBuilt 2017 · S/N 3278N137DSOrr Sam L Jr · Buford, GABuilt 2003 · S/N 70558N137GLynes Geoffrey · Halifax, MAS/N 60221N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025N137JSCompound Holdings LLC · Auburn, NYBuilt 1994 · S/N S1692N137JWNetwork Sales & Leasing Inc · Newtown, PABuilt 2011 · S/N 537-2011N137LHAero Holdings LLC · Palm City, FLBuilt 2006 · S/N 11137N137MEChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8420N137MWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 137N137NAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N 61P06997963334N137NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010008N137PCFlight Fundamentals Inc · Willcox, AZBuilt 2005 · S/N 1403-2005N137RCowboy Up Aviation LLC · Frenchglen, ORBuilt 1995 · S/N 804N137RJUaa International Inc · La Verne, CABuilt 1999 · S/N 172S8296N137SMarshall James W · Neptune Beach, FLS/N 20316N137SDHann Joseph C · Flemington, NJBuilt 1995 · S/N 3246002N137TDWw Flying Services LLC · Waller, TXBuilt 2013 · S/N 2300N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415N137TTBk Aviation Inc · Mansfield, TXBuilt 1986 · S/N 7-0237
Back to AD 2006-10-21