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.

N530ZMccowan Holdings LLC · Lexington, KYBuilt 2006 · S/N 41606N541VAColumbia Associates LLC · Potomac Falls, VAS/N 41608N542BP777 Air LLC · Bowling Green, KYBuilt 2006 · S/N 41674N543CACurtin Terrence R · Lititz, PABuilt 2006 · S/N 41603N54LKJoppa Aviation LLC · Charlottesville, VABuilt 2005 · S/N 41533N5500XWehrs Aviation LLC · Oro Valley, AZBuilt 2006 · S/N 41602N550GRClark Robert E · Meridian, MSBuilt 2001 · S/N 40015N554ZCaliber Aircraft LLC · Greensboro, NCBuilt 2008 · S/N 411057N555VAEscape Velocity LLC · Driggs, IDBuilt 2004 · S/N 41033N55NTNew Tricks LLC · New Castle, NHBuilt 2007 · S/N 41775N567JJCarefree Coach LLC · Thayne, WYBuilt 2005 · S/N 41077N567MB1 And 3 Lc · Jenks, OKBuilt 2002 · S/N 40052N5688FLink John Ernest · Hereford, TXS/N 41566N56MBNutacair400 LLC · Deland, FLBuilt 2008 · S/N 411029N574RMCardinal Enterprises LLC · Denver, COBuilt 2004 · S/N 41007N576BSC&J Aerobiz LLC · Madison, ALBuilt 2005 · S/N 41059N577STPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 411091N581GLBarnes Roy Rawlings Jr · Morehead City, NCBuilt 2009 · S/N 411129N583WPWp583 Enterprises LLC · Camarillo, CABuilt 2007 · S/N 41740N588PFBurke Farm Management Service Inc · Waynesboro, GABuilt 2009 · S/N 411145N58VGQualitair LLC Trustee · MichelstadtBuilt 2006 · S/N 41640N590JGMark V Aviation LLC · Missoula, MTBuilt 2002 · S/N 40044N5969HVan Bortel Aircraft Inc · Arlington, TXS/N 41788N599KPrecision Flight Aviation LLC · Springfield, ORBuilt 2006 · S/N 41692N59MMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2003 · S/N 42004N5EMShark Lady LLC · Sarasota, FLBuilt 2006 · S/N 41592N600TZStevens James · New Port Richey, FLBuilt 2007 · S/N 41725N609RQGreenbrier Classic Cars LLC · Whitefish, MTBuilt 2007 · S/N 41752N610BCLoki Operations LLC · San Jose, CABuilt 2006 · S/N 41683N611RJRj 400 LLC · Iowa City, IAS/N 41044N612SBGronemeyer Jens · Deland, FLBuilt 2004 · S/N 41013N613JMAngel One Aviation LLC · Pittsburgh, PABuilt 2006 · S/N 41583N615MPMorning Star Transportation Inc · Dardanelle, ARBuilt 2001 · S/N 40017N616MSBledsoe Bobby H · Hot Springs, ARS/N 40047N617SSN617ss LLC · Sylvania, OHBuilt 2009 · S/N 411127N618CJYou Are Too Nosey LLC · Wilmington, DES/N 41032N618GDd Air LLC · Lititz, PABuilt 2006 · S/N 41619N619VBDe Paul Steven T DBA · Annandale, NJBuilt 2008 · S/N 411037N620VBField Lynn Arthur · Spring Branch, TXBuilt 2008 · S/N 411094N621SLFarm Boys Investments LLC · Los Altos, CABuilt 2005 · S/N 41510N623THSaquatucket Adventures LLC · Wilton, CTBuilt 2007 · S/N 41763N626ERJeff Lucken LLC · Winger, MNBuilt 2006 · S/N 41669N628BBAmerican Lumber And Plywood Inc · Guntersville, ALBuilt 2005 · S/N 42073N634KCapital Air Service LLC · Tallahassee, FLBuilt 2007 · S/N 41735N63TEMcclung Stephen M · Heath, TXBuilt 2006 · S/N 41707N641WB3m Ranch LLC · Wittmann, AZBuilt 2006 · S/N 41676N6421ZRich Of Peak Aviation LLC · Frisco, TXBuilt 2007 · S/N 42569N644STCohen Steven B · Safety Harbor, FLBuilt 2005 · S/N 42079N64SGCamp Illahee Inc · Brevard, NCBuilt 2006 · S/N 42549N6500BAndrews Aviation LLC · Spartanburg, SCBuilt 2002 · S/N 40043
Back to AD 2007-07-06 R1