OpenAirDocs.org
AD 2007-07-06 R1

Registered aircraft · 691

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

N162CAWdf Montana LLC · Kalispell, MTBuilt 2007 · S/N 41772N166DSJagar Holdings LLC · Fort Worth, TXS/N 42070N166TTTruex Paul F · Sarasota, FLBuilt 2010 · S/N 411156N169HTAerie Leisure Inc · Phoenix, AZBuilt 2005 · S/N 41054N169PJBernard Douglas A · New Iberia, LABuilt 2005 · S/N 41065N169SWFluxtronic · Nashville, TNBuilt 2009 · S/N 411136N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008N171TBMaritime Aviation Security Team · Wilmington, NCBuilt 2002 · S/N 40045N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035N176JMBinkowski John · Washingtn Twp, MIBuilt 2008 · S/N 411041N1800HSanders Trent J · Redway, CABuilt 2003 · S/N 42009N181LDL&M Columbia 181 LLC · Chandler, AZBuilt 2007 · S/N 41643N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043N194LFRidan Investments Inc · Boerne, TXS/N 41630N1997Church Aviation LLC · Christmas Valley, ORBuilt 2007 · S/N 41795N1KVParagon Aviation LLC · Greenland, NHBuilt 2003 · S/N 40063N209DWWhite Columbia Inc Trustee · Wilmington, DEBuilt 2005 · S/N 41504N212CJJci Flight Management LLC · Tuscaloosa, ALBuilt 2008 · S/N 411065N212TJ212tj LLC · Monterey, CABuilt 2004 · S/N 41038N213LBPetro Larry D · Washington, DCBuilt 2004 · S/N 42051N214HLGulf Sun Vacation Rentals LLC · Port Saint Joe, FLBuilt 2006 · S/N 41622N215CTTellam Allan R Trustee · Chandler, AZS/N 41646N218APPeterson Jeff W · Bristol, MES/N 41731N21MGVortex Aviation LLC · Lafayette, LABuilt 2003 · S/N 42034N21XCHeaton Joshua · Allen, TXBuilt 2000 · S/N 40007N221WBOtter Rock Aero LLC · Newport, ORBuilt 2005 · S/N 41091N222BYRda Solutions LLC · Fort Worth, TXBuilt 2004 · S/N 41022N223GSN771cd LLC · Missoula, MTBuilt 2007 · S/N 42555N223LE&M Aircraft LLC · Baton Rouge, LABuilt 2006 · S/N 41680N223SMDickey Michael Patrick · Perry, FLBuilt 2006 · S/N 41657N225KWZia Air LLC · Hagerman, NMBuilt 2006 · S/N 41671N227PMEastern Stearman Inc Trustee · Leesburg, VAS/N 41750N227SMIpme Management Corp · Jefferson, GABuilt 2004 · S/N 41011N22CAN22ca LLC · Ennis, MTBuilt 2008 · S/N 421003N230SX2z West LLC · Alpine, WYBuilt 2004 · S/N 41045N232CHHoover Charles C Jr · Lake Wales, FLBuilt 2006 · S/N 41696N234KTCessna 182 LLC · Kitty Hawk, NCBuilt 2004 · S/N 41023N235DLPegasus Royalty Group LLC · Bozeman, MTBuilt 2006 · S/N 41571N235DTEntech Instruments Inc · Simi Valley, CAS/N 411066N235DWAir 4 LLC · Oakland, MES/N 41766N235JARabosky Gary · Frenchtown, NJBuilt 2008 · S/N 411102N235JLKm Aero Holdings LLC · Wilmington, DEBuilt 2006 · S/N 41701N235MTBeacon Aviation LLC · Chatham, MAS/N 41754N235SLNce Inc · Tucson, AZBuilt 2007 · S/N 41746N236RSSchoombee Clinton John · Murrieta, CABuilt 2004 · S/N 41003N239BCPhillips John S · Bristol, RIBuilt 2006 · S/N 41621N23KPSp Aviation Inc · Hayward, CABuilt 2004 · S/N 41004N240AFColumbia Av8ors Inc · Dover, DEBuilt 2005 · S/N 41525
Back to AD 2007-07-06 R1