AD 2002-16-07

Registered aircraft · 985

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

N24YDHezmalhalch Keith P · Napa, CABuilt 2007 · S/N 1DK427CN24YTBadger Air LLC · Wilmington, DEBuilt 2017 · S/N 125N2519EPrice Donald · Holdenville, OKBuilt 2007 · S/N 112N254DHLarson Donald J · Lillian, ALBuilt 2007 · S/N 07SC046N255MGCentral Valley Flight School LLC · Hanford, CABuilt 2011 · S/N 087/USN2569VJohnson Ralph Timothy · Fuquay Varina, NCBuilt 2007 · S/N 07-237N256RJHolm Russell R · Andover, MNBuilt 2007 · S/N T01045N2570CRempel Johan B · El Paso, TXFirst renewal noticeBuilt 2007 · S/N 07-238N2573DCoenen Lance G · North Augusta, SCS/N 03000911N2585Harriman Merrill William · West Ossipee, NHBuilt 2019 · S/N 70507085N258DHSwan Lake Aviation Corp · Mankato, MNBuilt 2006 · S/N 8411N258SGCircling Sky LLC · Reno, NVBuilt 2025 · S/N 12-058N259APConsolidated Leasing And Management LLC · Lafayette, LABuilt 2021 · S/N 00141N2605TDutt Kevin · Brentwood, CABuilt 2006 · S/N 2006-096N260JLClover Park Technical College · Lakewood, WABuilt 2016 · S/N 176/USN262SCDearing Keven L · Buffalo Center, IABuilt 2007 · S/N S60011-043N262SMMagnuson D Stephen · Sheridan, WYBuilt 2015 · S/N 1298262N2630CBrown Russell C · Howey In The Hills, FLBuilt 2005 · S/N 0020N2646CBrown Russell C · Howey In The Hills, FLBuilt 2004 · S/N 0017N2647CBrown Russell C · Howey In The Hills, FLBuilt 2001 · S/N 0016N264CBMccalla Richard K · Covington, TNBuilt 2015 · S/N JA418-11-14N2650CBrown Russell C · Howey In The Hills, FLBuilt 1994 · S/N 0019N265JHRichardson Roger D · Hendersonville, TNS/N 1061SDN266ACGo Gyro LLC · Essex, MDBuilt 2012 · S/N 011N266CPThooft Marlowe L · Russell, MNBuilt 2009 · S/N JAESC0147N2698THughes Lanny A · Collierville, TNBuilt 2007 · S/N 0412N26KBKrishnan Sunil G · San Rafael, CABuilt 2003 · S/N T03088N26WUDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2025 · S/N VSWX121A0188N2701DDewhurst Sebastian J · Lithia, FLBuilt 2008 · S/N 7-6631N270CMVidovich David F · Olmsted Twp, OHBuilt 2019 · S/N 283/USN270DGRed Owl Flying Service · Los Lunas, NMBuilt 2010 · S/N 7-7166N271SFN291ag Co · Wilmington, DEBuilt 2013 · S/N M01050N2729KBurnett James W · Huntsville, ALS/N 09970815N2732AHafner Terrance W · Winter Haven, FLBuilt 2002 · S/N 000592N2742NSizemore Albert D · Ocoee, FLBuilt 2005 · S/N T05049N2749NAgave Aviation LLC · Austin, TXBuilt 2005 · S/N T05075N274TATumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2014 · S/N 134/USN274TLForman Thoedore L · Westminster, MDBuilt 2025 · S/N 02220102N2750NRusu Teofil Lucian · The Colony, TXS/N T05050N277CGGuarno Adam · Milton, FLBuilt 2004 · S/N 1MK277CN277TTMetz Transportation LLC · Browns Valley, MNBuilt 2014 · S/N JA 359-03-14N278ADStemme LLC · Appleton, WIBuilt 2008 · S/N 11-122N279DEPeter Pan LLC · Salida, COBuilt 2007 · S/N CAL02671SN280EPSiddoway Jeff DBA · Terreton, IDBuilt 2024 · S/N A443ULSN280JHAirflight LLC · De Pere, WIBuilt 2006 · S/N 12051716N280QTTruax Wesley M · Macdoel, CABuilt 2024 · S/N 256 M912N281KRAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2022 · S/N 12-047N2838AOlsen Daniel F · St George, UTBuilt 2003 · S/N A 136 PEGN2840NDucote Christopher N · Bunkie, LAS/N D98912C0HK0297N284USGarabedian John H · Southborough, MABuilt 2009 · S/N 09SC289
Back to AD 2002-16-07