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.

N82MAPdmi Client Sales Support LLC · Poland, OHBuilt 2017 · S/N 1197N835CAHill David C · Lancaster, NHBuilt 2012 · S/N 642N835KMMk Partners LLC · Portsmouth, RIBuilt 2021 · S/N 1365N836EAPella Assets LLC · Natchez, MSBuilt 2013 · S/N 657N838GKInternational Air Services Inc Trustee · Carson City, NVBuilt 2015 · S/N 1098N838RAT206 Aviation LLC · Stockton, CAS/N 71N842CARich Valley LLC · Groton, MABuilt 2013 · S/N 672N842MABbns2 LLC · Mooresville, NCBuilt 2007 · S/N 424N843BHGaylord Theodore Scott DBA · La Grange, CABuilt 2001 · S/N 196N847MCCanoecouple Inc · Winnetka, ILBuilt 2017 · S/N 1162N848DBCrimson Maroon LLC · Hollywood, FLBuilt 2018 · S/N 1233N84HSGc N84hs LLC · Layton, UTS/N 50N850AAPsi Star Aviation LLC · Chattanooga, TNBuilt 2007 · S/N 399N850ABFirefly Consulting LLC · Wausau, WIBuilt 2006 · S/N 377N850ADN850ad LLC · Jonesboro, ARBuilt 2008 · S/N 444N850AGSeventh Letter Capital LLC · Oxford, MSBuilt 2007 · S/N 414N850AHSchell Brothers II LLC · Rehoboth Beach, DEBuilt 2009 · S/N 529N850AJAj Air Ltd · Massillon, OHBuilt 2011 · S/N 602N850APBurns Nicholas J III · Almond, WIBuilt 2006 · S/N 379N850AVM&M Aviation LLC · Sacramento, CABuilt 2011 · S/N 572N850AXRerops Transport LLC · Oakley, KSBuilt 2010 · S/N 557N850AZSalt River Aviation LLC · Sagle, IDBuilt 2006 · S/N 384N850BAB & A Adventures LLC · Clearwater, FLBuilt 2013 · S/N 667N850BDColumbia Aircraft Sales Inc · Groton, CTBuilt 2008 · S/N 446N850BGWren Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 367N850BLRockmount Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 420N850BTCardinal Roots LLC · Middletown, DEBuilt 2007 · S/N 433N850BXPro Water Solutions LLC · Henderson, TXBuilt 2012 · S/N 641N850BZAm Trans 731 LLC · San Antonio, TXBuilt 2007 · S/N 427N850CAQualitair LLC Trustee · MichelstadtBuilt 2010 · S/N 552N850CEAda Coca-Cola Bottling Co · Ada, OKBuilt 2012 · S/N 584N850CFLily Loubean LLC · Gary, INBuilt 2008 · S/N 462N850CGTravel Solution LLC · Terre Haute, INS/N 563N850CSBeaver Air LLC · Houston, TXBuilt 2013 · S/N 668N850DDDella Costa Jorge · Houston, TXBuilt 2006 · S/N 370N850DKTexoma Industries Of Graham LLC · Graham, TXBuilt 2009 · S/N 496N850DTAtlas 850 Wp LLC · Chattanooga, TNBuilt 2006 · S/N 359N850DXMonteiro Aviation LLC · Newark, DEBuilt 2008 · S/N 484N850EValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 537N850EDTachys Aviation LLC · Austin, TXBuilt 2008 · S/N 473N850EESpeedhawk Aviation LLC · Rancho Santa Fe, CABuilt 2010 · S/N 548N850ELErickson Logging And Construction Inc · Gig Harbor, WABuilt 2006 · S/N 352N850FAFly Through Tx LLC · Boerne, TXBuilt 2008 · S/N 471N850FNDm Advisors Inc · Garland, TXBuilt 2012 · S/N 624N850FPBrical Enterprises LLC · Belton, MOBuilt 2013 · S/N 664N850GHKcc Av LLC · Fayetteville, ARBuilt 2011 · S/N 594N850GMMannup LLC · Jasper, INBuilt 2010 · S/N 535N850GSInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 562N850GVN850gv LLC · Austin, TXBuilt 2013 · S/N 655N850GXBtm Leasing LLC · Cabot, ARBuilt 2008 · S/N 435
Back to AD 2007-03-17 R1