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.

N850UUis Aviation Services Inc · Pleasant Grove, UTBuilt 2006 · S/N 380N850VFMechanical Pencil LLC · Springfield, MOBuilt 2010 · S/N 532N850VJPowdercat8 LLC · Steamboat Springs, COBuilt 2011 · S/N 577N850VMVm Aviation LLC · Elkhorn, NEBuilt 2011 · S/N 598N850VVPinion Aircraft LLC · Menlo Park, CABuilt 2000 · S/N 166N850WARlw Aviation Technologies LLC · Round Rock, TXBuilt 2011 · S/N 597N850WCBlue Mesa LLC · Bend, ORBuilt 2011 · S/N 599N850WEAt Marko LLC · Chapel Hill, NCBuilt 2007 · S/N 411N850WKDenali Asset Management LLC · Incline Village, NVBuilt 2009 · S/N 507N850WMDotson286 LLC · Bowling Green, KYBuilt 2006 · S/N 353N850WPSustainable Fun LLC · Houston, TXBuilt 2009 · S/N 520N850WTValiair Limited Company Trustee · Casper, WYBuilt 2009 · S/N 526N850WWDelta Bravo Air Services LLC · Telluride, COBuilt 2009 · S/N 505N850XCole Plane LLC · Marshall, MNBuilt 2012 · S/N 629N850ZMLewis Peter T · Santa Barbara, CABuilt 2012 · S/N 630N850ZSWayne Four LLC · Sugar Land, TXBuilt 2013 · S/N 654N850ZZKinentum LLC · Cody, WYBuilt 2012 · S/N 623N851JKAviationbykarpel LLC · Saint Louis, MOBuilt 2013 · S/N 682N851TBAero Holdings LLC · Palm City, FLBuilt 2006 · S/N 373N852AMWings II LLC · Baltimore, MDBuilt 2007 · S/N 404N852CARebbenkyo Association LLC · Wilmington, DEBuilt 2007 · S/N 423N852PSSchickedanz Aviation LLC · Fort Madison, IABuilt 2013 · S/N 660N852TBAvio Air LLC · Menominee, MIS/N 666N852XKahube Aero LLC · Nephi, UTBuilt 2009 · S/N 497N853WPAirmedical Services LLC · Albuquerque, NMBuilt 2012 · S/N 636N854SASimonson Aero LLC · Grand Forks, NDBuilt 2008 · S/N 440N854UC854uc LLC · Eagle, IDBuilt 2012 · S/N 644N855KPElj Northwest Inc · Aurora, ORBuilt 2008 · S/N 452N856BSCape Island Aviation LLC · Millville, NJBuilt 2010 · S/N 556N858PWQm Aircraft Leasing LLC · Boca Raton, FLBuilt 2024 · S/N 1536N859CABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 509N85FMAtlas Stone Capital LLC · Stamford, CTBuilt 2008 · S/N 469N85JKSor Aviation LLC · Laurel, MTBuilt 2008 · S/N 454N85KKHat Creek Construction & Materials Inc · Burney, CABuilt 2006 · S/N 386N85NCAxis Aviation LLC · Boerne, TXBuilt 2014 · S/N 1032N85VZFlying Phox LLC · Palm Beach, FLBuilt 2020 · S/N 1353N85ZGAdventure Wings LLC · Shrewsbury, MABuilt 2008 · S/N 480N860CASale Reported · Prattville, ALSale reportedBuilt 2011 · S/N 596N860JBN62vm LLC · Lake Geneva, WIBuilt 2003 · S/N 273N862AWLake Mohawk Associates LLC · Solon, OHBuilt 2024 · S/N 1530N862DCSeidel Robert P · Belle Mead, NJBuilt 2013 · S/N 679N868ATLets Go Leasing LLC · La Pointe, WIBuilt 2002 · S/N 232N868JAWard John Jr · Longview, TXBuilt 2015 · S/N 1063N86CHCarlyle Air LLC · Morristown, TNBuilt 2010 · S/N 543N86HKMcgillivray Patricia · Ventura, CABuilt 2014 · S/N 1009N870MBRegistered aircraftBuilt 2009 · S/N 522N874CADeming Enterprises Inc · Perry, OHS/N 360N876DTRegistered aircraftN-number assigned (import), not yet registeredS/N 1680N87JHAaa Roofing Co Inc · Indianapolis, INBuilt 2016 · S/N 1114N8800Tvs Aviation LLC · Nashville, TNBuilt 2001 · S/N 202
Back to AD 2007-03-17 R1