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.

N2694WDickerson Steven Micheal · Tipp City, OHBuilt 1966 · S/N 1009N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218N2696RBowen Diane M · Newbury, MABuilt 1969 · S/N 28R-35248N2696TRsp Aero LLC · Griffin, GABuilt 1971 · S/N 28-7205087N2696WButler Collin · Danvers, MABuilt 1966 · S/N 3325N2698WLivesay Wallace · Friendswood, TXBuilt 1966 · S/N 1011N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318N2699WKingman Connor Joseph · Lemoore, CAS/N 1012N269AReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 1050403N269ATSnyder Arthur P · Trevorton, PABuilt 2005 · S/N 1001N269BTorres Ramon A · Mulberry, FLFirst renewal noticeBuilt 1958 · S/N 127N269BFLehmann Micheal · Lena, ILBuilt 2003 · S/N 21421N269BMOlsen Jared · Phoenix, AZBuilt 2002 · S/N 60130N269CPCutler Adam Wilson · Kennebunk, MEBuilt 2000 · S/N 80269N269DDAircraft Solutions Group LLC · Englewood, COBuilt 2005 · S/N 172S9981N269EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13509N269FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10885N269HAN269ha LLC · Manassas, VAS/N S1406N269HHCaprock Technical Services Inc · Kempner, TXS/N 12-0041N269JPBrones Jon P · Blanco, TXBuilt 1977 · S/N 670611N269KGMvt Aviation LLC · Magnolia, TXBuilt 2013 · S/N CH402N269KMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020099N269MDCactus Air Force LLC · Carson City, NVBuilt 1963 · S/N 33-0175N269MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881367N269MPGustafson H Clayton · Woodbury, CTBuilt 1980 · S/N 32R8029007N269MRAgl LLC · Othello, WABuilt 1997 · S/N S1753N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269RHUnterreiner Dean · Prince George, VABuilt 1994 · S/N 20046N269RTTodd Jon R · Georgetown, CABuilt 2010 · S/N 72891N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061N269SFHarvey Kandace · Snohomish, WABuilt 1979 · S/N 690795N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363N269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationBuilt 1999 · S/N S1776N269TJSenninger Thomas P · Clermont, FLBuilt 2000 · S/N S1807N269TPPhoenix Leasing LLC · Menomonee Falls, WIBuilt 2000 · S/N 0110N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269VCRegistered aircraftBuilt 1992 · S/N S1609N269WFThomas Wilmer C · Fairbanks, AKBuilt 1999 · S/N 30007CN269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606N269ZIziair LLC · Mclean, VABuilt 2006 · S/N 3257407N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693N26AESwallows Inc · San Jose, CABuilt 1976 · S/N 230(2106)N26AUMaximum Entropy Inc · Wilmington, DEBuilt 1979 · S/N 282 (37-002)N26BMRegistered aircraftBuilt 1999 · S/N 18280659N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219N26BYSnohoacro LLC · Mukilteo, WABuilt 2004 · S/N 963-2004N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26CXCiholas Philippe A · Sedgwick, KSBuilt 1970 · S/N 244949N26DCAce Aviation LLC · Reading, VTBuilt 1965 · S/N 32-64N26DHZurinsky Richard · Port Orchard, WABuilt 1978 · S/N DH-1
Back to AD 2006-10-21