AD 2002-19-03

Registered aircraft · 12,723

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-19-03')
    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-19-03')
  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.

N1044NMaule Flight Inc · Moultrie, GABuilt 1996 · S/N 25006CN10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194N1045YRovers Bradley S · Chazy, NYBuilt 2005 · S/N 18281571N1047UStueve'S Certified Organic Dairy · Oakdale, CABuilt 1998 · S/N 23043CN1048DDumbravo Dustin C · Yorktown, VABuilt 2001 · S/N 27-0315N1049TRoberts Kevin C · Athens, GABuilt 2003 · S/N 27-0319N1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeBuilt 1975 · S/N 32-7540132N104ABPeterson Kevin D · Peoria, AZBuilt 1998 · S/N 18280280N104ALDinardi Allen J · Jacksonville, ORBuilt 2010 · S/N 40369N104AZJarrell Rodney M · Phoenix, AZBuilt 2014 · S/N 41226N104BKCharlie Alpha Bravo LLC · Spring Hill, KSBuilt 2012 · S/N 40125N104BRBelsaas Richard A · Rapid City, SDBuilt 2007 · S/N 40373N104CDOlson Timothy D · Elk Mound, WIBuilt 2006 · S/N 40170N104DPMajul Enterprises Inc · Saint Petersburg, FLS/N 3340N104EHaas Bruce F · Lynden, WAS/N 586N104EEWestfall Benjamin C · Coeur D Alene, IDBuilt 2019 · S/N 001N104EPEarwood Edward A · Sonora, TXBuilt 2012 · S/N 40820N104GKIndigo Bunting Aviation LLC · Morristown, NJBuilt 1977 · S/N 32R7780461N104GRMargolis David · Tucson, AZBuilt 2010 · S/N 40763N104JGRoscioli Lamberto · Lighthouse Point, FLBuilt 2008 · S/N 40240N104KGKing & Co LLC · Arroyo Grande, CABuilt 2001 · S/N T18208008N104LDMasys Daniel R · Lincoln, CABuilt 2007 · S/N 40448N104LJFeldhousen Larry A · Burlington, COBuilt 2005 · S/N 40109N104MEMathis Mark D · Richmond, TXFirst renewal noticeBuilt 2005 · S/N 40108N104MFEccker Donald E · Ramona, CABuilt 2016 · S/N 40834N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210N104NRainey Norman W · Surprise, AZBuilt 2007 · S/N 40348N104RGWeiss Elliott · Fresno, TXS/N 004N104TEN104te LLC · Tucumcari, NMBuilt 2011 · S/N 13093N104WHGreycal Enteprrises Inc · Lake Mary, FLBuilt 2005 · S/N 3232046N104XPRv X Aviation LLC · Draper, UTBuilt 2006 · S/N 40111N104ZURuttler James J · Bremerton, WABuilt 2015 · S/N 41103N1050BNine1on Industries LLC · Helena, MTBuilt 2001 · S/N 27-0312N1050QCouch Kelly P · Elk Grove, CABuilt 2000 · S/N 27-0310N1051ZDranttel Timothy John · Fuquay Varina, NCBuilt 1998 · S/N 25021CN1053BLoveland Inc · Vance, MSBuilt 2005 · S/N 18281569N1054QTaylor Hauling II LLC · Laurel, MSBuilt 1977 · S/N 32-7740045N1054TInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 26004CN10555Mccrea Daniel B · Waldport, ORS/N 23055CN1057TMclane Trailer Sales Inc · Poplar Bluff, MOBuilt 2005 · S/N 18281572N105CBFlying Squirrel Aviation LLC · Blacksburg, VABuilt 1972 · S/N 31041N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419N105DGFraser And Daughter LLC · Saint Augustine, FLBuilt 2024 · S/N 4636857N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322N105JMBullard Roy P · Granbury, TXBuilt 2006 · S/N 18281743N105RCOlds Rodger C · Prescott Valley, AZS/N 3201N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163N105TLSlay Brothers Enterprises LLC · Winter Haven, FLBuilt 2003 · S/N T18208213N1062UNathan John K · Seabrook, TXS/N 32-40070N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440
Back to AD 2002-19-03