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.

N2535PN2535p LLC · Verona, WIBuilt 2006 · S/N 41568N2535XAviator Ventures LLC · Valrico, FLBuilt 2006 · S/N 41573N25367Robinson Stephen C · Garrison, NDBuilt 2005 · S/N 41503N2538MWarren James Rent · Rapid City, SDBuilt 2005 · S/N 41081N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078N2539XWhy Drive LLC · Houston, TXBuilt 2006 · S/N 42505N2540MGlobal Emergency Services LLC · Beaumont, TXS/N 41031N2541AEnergy307 LLC · Casper, WYBuilt 2005 · S/N 41085N2541MWard Gregory D · Philadelphia, MSBuilt 2004 · S/N 41028N2542TCavu Aviation LLC · Searcy, ARBuilt 2005 · S/N 41508N2544TSpindler Construction Corp · Logan, UTBuilt 2005 · S/N 41072N2544WJoseph Belew · Clarksville, TNBuilt 2005 · S/N 41530N2545BD & H Equities LLC · Helena, MTBuilt 2004 · S/N 41036N2545KToscano Holdings · Eads, TNBuilt 2004 · S/N 41039N2545TTrautman Bruce D · Minneapolis, MNBuilt 2005 · S/N 41080N2547TBuilding Eleven Ventures LLC · West Chester, OHBuilt 2006 · S/N 42503N25NHGrey Sky LLC · Bossier City, LABuilt 2008 · S/N 411071N262RKRegistration Pending · Corpus Christi, TXRegistration pendingBuilt 2006 · S/N 41649N268WGolf Links Inc · Hermitage, TNBuilt 2006 · S/N 42542N269GBG B A Aviation Inc · Wilmington, DES/N 40030N26VVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 40055N2730PRegistration Pending · Palm Harbor, FLRegistration pendingBuilt 2005 · S/N 41071N277JAMathieson Brett L · Rio Linda, CABuilt 2006 · S/N 41607N278ECAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41745N284KBRoper Lawrence F Jr · Georgetown, SCS/N 40068N28PDBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 41776N29HHPalmetto Aviation LLC · Annapolis, MDBuilt 2006 · S/N 41580N29KK29kk LLC · Manchester, MIBuilt 2003 · S/N 40071N2ESBuilding Solutions LLC · West Palm Beach, FLBuilt 2006 · S/N 41672N300HMEngage Communication Inc · Aptos, CABuilt 2001 · S/N 40011N300NVHolombo Lee C · Trenton, KYBuilt 2003 · S/N 40064N300TLAlls Peyton H · Raleigh, NCBuilt 2003 · S/N 40067N302DGBluebird Aero LLC · Wilmington, DEBuilt 2006 · S/N 41565N302RPMccollough Randy F · Belton, TXBuilt 2004 · S/N 41051N303LMRegistered aircraftBuilt 2002 · S/N 40041N305SMWinston James Eldon Jr · Granbury, TXBuilt 2006 · S/N 41688N307AG4th Down Aviation LLC · Provo, UTBuilt 2006 · S/N 41595N307JRSatellite Radio Management Inc · Hays, KSBuilt 2005 · S/N 41513N309JLHangar 15 LLC · Saint Martinville, LABuilt 2008 · S/N 411010N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046N312JGJoule Resources LLC · Bellaire, TXBuilt 2006 · S/N 41691N317TDEllmore Floyd Lester · Stafford, VABuilt 2009 · S/N 421016N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064N321BXBravo Xray LLC · Gainesville, FLBuilt 2007 · S/N 41799N323CLHoge John · Setauket, NYBuilt 2002 · S/N 40054N323YManthei Kurt E · Jacksonville, FLBuilt 2006 · S/N 42539N325SKInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 41528N325TSMorning Flight LLC · Woodbridge, VABuilt 2006 · S/N 41589N328TJTasker Jerome · Midland, GABuilt 2005 · S/N 41524N33HEShelton Barry · Austin, TXBuilt 2008 · S/N 411109
Back to AD 2007-07-06 R1