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.

N4468FIdahi Aviation LLC · Eagle, IDBuilt 2004 · S/N 41043N446SKFlying Montana LLC · Bozeman, MTBuilt 2006 · S/N 41714N450KSkylife Enterprises LLC · Long Beach, CABuilt 2008 · S/N 411052N450TFAirmart Inc · Lexington, KYBuilt 2008 · S/N 411025N454MCGc Aviation LLC · Arden, NCBuilt 2008 · S/N 411016N455MCHoffer William M · St Helena Is, SCBuilt 2009 · S/N 411148N464AGLoftus Jeffrey · Rapid City, SDBuilt 2006 · S/N 41574N465HDCorporate Air Services Inc · Salt Lake City, UTBuilt 2009 · S/N 411147N468CLVicash LLC · Dover, DEBuilt 2003 · S/N 42030N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071N474MMSeventy Weeks Management Inc · Las Vegas, NVBuilt 2006 · S/N 41704N475CAAttensity LLC · Denmark, MEBuilt 2006 · S/N 41563N4777DZulu Aviation Partners LLC · Helena, MTS/N 411081N477MTFirst Lease Inc · Britton, SDBuilt 2008 · S/N 411073N478ABM1 Executive Flying LLC · Lewes, DEBuilt 2009 · S/N 411130N47MRFree Bird Aviation LLC · Wasilla, AKS/N 41057N48PDCrown Of Texas Ventures LLC · Panhandle, TXS/N 41002N495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032N497BCBarnes William · Hagerstown, MDBuilt 2010 · S/N 411157N498RDJacobsen Aviation LLC · Avoca, IABuilt 2006 · S/N 41685N499RARenegade6 Aviation LLC · Woodbridge, VABuilt 2008 · S/N 411042N501ARToce Leasing LLC · Frisco, TXBuilt 2008 · S/N 411013N501PFTraumflieger LLC · Lancaster, PABuilt 2001 · S/N 40021N503RAAirplanes And Coffee LLC · Kalispell, MTBuilt 2001 · S/N 40024N504JLJade Management Inc · Hailey, IDBuilt 2004 · S/N 41020N507NANasa Langley Research Center · Hampton, VABuilt 2000 · S/N 40008N510MLMach Plus LLC · Pawleys Island, SCBuilt 2008 · S/N 411055N512PSRegistered aircraftBuilt 2006 · S/N 41581N512RPVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 411084N512TSOldnettle Jeffrey · Wetumpka, ALBuilt 2007 · S/N 41796N512VDavid Golden Md Inc · Los Angeles, CABuilt 2007 · S/N 41736N512XPilot Henry LLC · Big Prairie, OHBuilt 2004 · S/N 41041N513STAllensworth Timothy Lee · Bladenboro, NCBuilt 2009 · S/N 421019N514TTWilson Kirk Allan · Phoenix, AZBuilt 2006 · S/N 41612N515ATFlexpak Corp · Bend, ORBuilt 2006 · S/N 41664N515MMUtiliplex LLC · Hickory, NCBuilt 2004 · S/N 41046N517XEezrx LLC · Athens, OHBuilt 2008 · S/N 411117N518LSeehimfly LLC · Spring, TXBuilt 2003 · S/N 42028N5194CDk Advanced Management Solutions Inc · Rockledge, FLBuilt 2008 · S/N 411079N5194YNorthgate Aviation LLC · Colorado Springs, COBuilt 2008 · S/N 411007N5195LAdams Charlie H Jr · Blairsville, GABuilt 2008 · S/N 411015N519PWBlackmore Roberta L · Durango, COBuilt 2006 · S/N 41610N51GKHelgeson Todd R · Port Orange, FLBuilt 2004 · S/N 41042N51KJWoodward Perry James · San Jose, CABuilt 2008 · S/N 411113N521GSProteng Distribution Inc · Wellington, FLBuilt 2007 · S/N 41765N522LGBagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41609N522RHRoach Kyle Wayne · Lubbock, TXBuilt 2008 · S/N 411038N523BASale Reported · Rexburg, IDSale reportedBuilt 2005 · S/N 41529N524TGWillits Tamara L · Lawrence, KSBuilt 2008 · S/N 411023N526STSims Stuart P · Walnut Creek, CABuilt 2007 · S/N 41726
Back to AD 2007-07-06 R1