OpenAirDocs.org
AD 2007-03-17 R1

Registered aircraft · 999

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-03-17-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-03-17-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.

N626DMStraight Aero LLC · Cleveland, OHBuilt 2000 · S/N 170N6272BH&S Aircraft Holdings Inc · Hazelwood, MOBuilt 2005 · S/N 328N62LMBroadway Air LLC · Huntsville, ALS/N 67N636MAKourakos William Jr Trustee · Coral Gables, FLBuilt 2013 · S/N 673N639CWPb Air LLC · Americus, GABuilt 2012 · S/N 639N63TPHot Air LLC · Cambridge, MABuilt 1997 · S/N 128N64MAOllie Aviation LLC · Melbourne, FLS/N 1371N650DMMaroon Creek LLC · Aspen, COBuilt 1993 · S/N 85N651WBContrail Inc · Bethlehem, PABuilt 2006 · S/N 364N654CWRivercity Aviation LLC · Coeur D Alene, IDBuilt 2008 · S/N 439N656LDWin Up Inc · Cookeville, TNBuilt 2013 · S/N 656N656WConn Aviation LLC · Millersburg, OHBuilt 2007 · S/N 402N657MAKtnc Leasing LLC · Lexington, KYBuilt 2013 · S/N 650N661EKGi Aviation LLC · Denver, COS/N 61N662MEOn The Numbers Inc · Omaha, NES/N 1391N666DXMkair Holdings LLC · Fort Lauderdale, FLBuilt 2022 · S/N 1434N667CAYintash Aviation LLC · Seminole, TXBuilt 2016 · S/N 1117N668W231pb LLC · San Francisco, CABuilt 2014 · S/N 1013N671EAMjd58 LLC · Newark, DEBuilt 2013 · S/N 671N67BPTbm N67bp Inc Trustee · Wilmington, DEBuilt 2016 · S/N 1110N67VVRivergates Ivy Warp LLC · Boca Raton, FLBuilt 2011 · S/N 600N688MAPoc One LLC · South Hill, VABuilt 2012 · S/N 622N68TFRegistered aircraftS/N 26N68WSJet Affair LLC · Lake In The Hills, ILBuilt 2023 · S/N 1501N690CKlass Investments LLC · Marksville, LABuilt 2002 · S/N 238N693MACurrie Partners Inc · San Diego, CABuilt 2004 · S/N 293N694BHAlpenglow Airways LLC · Aspen, COBuilt 2023 · S/N 1472N694PB1a Asset Holdings LLC · Novi, MIBuilt 2014 · S/N 1043N69CVDeliberate Air LLC · Brigham City, UTBuilt 2015 · S/N 1053N700ADRkefs LLC · Big Lake, MNS/N 250N700ANAi Kinetics LLC · Los Altos, CABuilt 1998 · S/N 132N700APSutton Bay Leasing LLC · Excelsior, MNBuilt 2001 · S/N 190N700AYKellman Act Services Inc · Pacific Palisades, CABuilt 2001 · S/N 191N700BFFoxtrot Transportation LLC · Saint Charles, MOBuilt 1992 · S/N 53N700BMMason Amelia Holdings LLC · Boerne, TXBuilt 2003 · S/N 270N700BNBostic Capital Group LLC · Prestonsburg, KYBuilt 2001 · S/N 203N700BQMjm Aviation LLC · Fowler, CABuilt 2004 · S/N 298N700BSPark Rapids Avionics Inc · Park Rapids, MNBuilt 1991 · S/N 11N700CFN7880l LLC · Port Charlotte, FLBuilt 1996 · S/N 123N700CLJupiter Equipment Leasing Inc · Garland, TXBuilt 2003 · S/N 266N700CSSocata 109 Inc Trustee · Wilmington, DEBuilt 1995 · S/N 109N700CTPatriot Contractors LLC · North Las Vegas, NVBuilt 2002 · S/N 236N700CVIlmo Adventures LLC · Kalispell, MTBuilt 2002 · S/N 221N700CZNexus Surgical Innovations Inc · Bozeman, MTBuilt 2004 · S/N 301N700DEPhoenix Trailers Aviation LLC · East Jordan, MIBuilt 2000 · S/N 184N700DMClearance Clarence LLC · Lubbock, TXBuilt 2004 · S/N 305N700DTNorth Coast Ventures LLC · Wilmington, DEBuilt 1998 · S/N 134N700DZTwo Oscar Three LLC · Saint Helena, CABuilt 2004 · S/N 295N700EBEcho Bravo LLC · Geneva, ILBuilt 2002 · S/N 215N700EJLyv 26 Inc Trustee · Wilmington, DEBuilt 2004 · S/N 291
Back to AD 2007-03-17 R1