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.

N679JDRamrath Joseph · Needham, MAS/N 411063N682YTVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N 41703N68LPAvt Holdings II LLC · Winston Salem, NCBuilt 2008 · S/N 411026N68LWWaconda Concepts LLC · Sturgis, SDBuilt 2007 · S/N 41782N6AAGeneral Property Development LLC · Bedford, NHBuilt 2008 · S/N 411100N6EYCsh Aviation LLC · Sheridan, WYBuilt 2004 · S/N 41005N6WTBig Sky Flight Solutions LLC · Helena, MTS/N 411101N701ARMac Air LLC · Costa Mesa, CABuilt 2007 · S/N 41793N7098CVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N 41631N711DVKendall Kevin · Blacksburg, VAS/N 41758N711LUE-Jane Tsai · Arcadia, CABuilt 2007 · S/N 41770N711NNHatton Leslie · Chesapeake, VAS/N 41614N711VRCjw Real Estate LLC · Haddonfield, NJBuilt 2006 · S/N 41715N713DWSierra Group LLC · Bend, ORBuilt 2006 · S/N 41694N714BRNickell Ventures LLC · Sheridan, WYBuilt 2006 · S/N 41661N714JMJ&S Landings LLC · Gypsum, COBuilt 2008 · S/N 411121N716JKWood Oscar Eugene III · Alexandria, VAS/N 42566N717CWAmerican Flying Club Inc · Arlington, VABuilt 2001 · S/N 40025N718PWCessna 400 LLC · Mesa, AZBuilt 2007 · S/N 41781N71ELCaptain Jb LLC · Findlay, OHBuilt 2006 · S/N 41613N721WBFox Gary A · Mebane, NCBuilt 2005 · S/N 41107N725EAMaple8 Holdings LLC · Dallas, TXBuilt 2008 · S/N 411018N726DNNelson Aero LLC · East Helena, MTBuilt 2006 · S/N 41684N728SMMasters In Flight LLC · Friday Harbor, WABuilt 2005 · S/N 41087N731EAExperience Aviation Inc · Opa Locka, FLBuilt 2005 · S/N 41518N73TXSee Robert W · Catawba, NCBuilt 2001 · S/N 40034N742CAEagle Talon Inc · North Augusta, SCBuilt 2007 · S/N 42544N747CWDynamic Engineering Inc · Van Buren, ARBuilt 2005 · S/N 41509N747SLWesley Kelley · Pontotoc, MSBuilt 2006 · S/N 42550N747VPSavfar Aviation Inc · Wilmington, DEBuilt 2005 · S/N 41092N749JBSkylands Group LLC · Wilmington, DES/N 41511N74CRCage Presnall C · Falfurrias, TXBuilt 2003 · S/N 40061N753MNR J Enterprise Inc · Newark, DEBuilt 2004 · S/N 41027N75LBL & A Bennett Second Family Lp · Renton, WABuilt 2001 · S/N 40014N761SRNikitin Alexey Pavlovich · Tigard, ORBuilt 2003 · S/N 40069N762CSWilliams James K Trustee · Yorba Linda, CAS/N 411111N765SMHarrison Edward G · San Francisco, CABuilt 2008 · S/N 411114N7711YM Three Fly LLC · Jacksonville, FLBuilt 2008 · S/N 411059N772TTBrightwater Enterprises LLC · Lakeway, TXBuilt 2004 · S/N 42058N77350Bottom Line Technologies Inc · Columbia, MDBuilt 2003 · S/N 42013N7743ECol4hms LLC · Erie, COBuilt 2006 · S/N 41665N774BWZone Five LLC · Saint Petersburg, FLBuilt 2008 · S/N 411070N7772ANorthern Computers Inc · Madawaska, MEBuilt 2008 · S/N 411035N777SBFamily Centered Medicine LLC · Lawrence, KSBuilt 2006 · S/N 41709N777XXAustex Aviation Group Inc · Austin, TXBuilt 2002 · S/N 40058N782KJSrl Investments LLC · Boone, IABuilt 2005 · S/N 42083N788WAnderson Harry R · Bainbridge Island, WABuilt 2001 · S/N 40022N789WBDale Scott A · Baltimore, MDBuilt 2001 · S/N 40029N78JEDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 411030N797TN797t Aviation LLC · Stanfield, NCBuilt 2003 · S/N 42031
Back to AD 2007-07-06 R1