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.

N188SJDaxen Logistic LLC · Chino, CABuilt 1993 · S/N 69N18SRW4 Air LLC · Willis, TXBuilt 2000 · S/N 161N1967HTbm 700 LLC · Denair, CAS/N 46N19DLDmc Aviation LLC · Jacksonville, FLBuilt 2017 · S/N 1188N19GSDel Rey Dock Company LLC · Key Largo, FLS/N 1637N1ETCalifornia Aerospace LLC · San Francisco, CABuilt 2023 · S/N 1516N1J1596 Inc Trustee · Wilmington, DEBuilt 2025 · S/N 1596N1TJCowboy Air LLC · Kingfisher, OKS/N 1338N1VCAlmeida Victor · Telluride, COBuilt 2014 · S/N 1022N20RFAffinity Air LLC · Fort Worth, TXBuilt 2011 · S/N 605N210CLPark Rapids Avionics Inc · Park Rapids, MNBuilt 2004 · S/N 303N211GRTribus Aviation LLC · Saint Louis, MOBuilt 2008 · S/N 494N212BWBoerne Flight Options LLC · Wilmington, DEBuilt 2018 · S/N 1229N212MPMp 212 LLC · Charlottesville, VABuilt 2023 · S/N 1467N213REWhital Enterprises LLC · Dover, DEBuilt 2002 · S/N 230N217DCEasterly Capital LLC · Beverly, MABuilt 2014 · S/N 687N217TMRegistration Pending · Boise, IDRegistration pendingBuilt 2001 · S/N 217N218LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 1496N21VBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 1364N220CHMedical Air Inc · Raleigh, NCBuilt 2021 · S/N 1380N220MARegistration Pending · Chestertown, MDRegistration pendingBuilt 2002 · S/N 248N221CM1106 Inc Trustee · Wilmington, DEBuilt 2016 · S/N 1106N222CSSeidner Steve Trustee · Monrovia, CABuilt 2014 · S/N 1014N223EARegal Air Partners I LLC · New Iberia, LABuilt 2005 · S/N 323N225WTMeridian Leasing Group LLC · Cincinnati, OHBuilt 2024 · S/N 1547N226AT226at Air LLC · Portland, ORBuilt 2017 · S/N 1206N226MDSolomon Aviation LLC · Northumberland, PAS/N 88N226RACorporate Aircraft Association · Forney, TXBuilt 2008 · S/N 482N227CHBlue Altitude LLC · Raleigh, NCBuilt 2005 · S/N 334N228KCJuliet Papa Kilo LLC · Seven Valleys, PABuilt 2022 · S/N 1458N228MEWhite & Stradley Pllc · Raleigh, NCS/N 49N22HPSts Inc · Wilmington, DEBuilt 2019 · S/N 1305N22MYLewitzke Holdings LLC · Weston, WIBuilt 2008 · S/N 443N230RCRydell Co · Sioux Falls, SDBuilt 2019 · S/N 1299N231SKMeridian Aviation Holding Co Inc · Teterboro, NJBuilt 2024 · S/N 1550N231TGRegistered aircraftBuilt 2023 · S/N 1477N232MA3mc Aviation LLC · Diboll, TXBuilt 2016 · S/N 1132N235SFScott Air LLC · Munster, INBuilt 2002 · S/N 251N236EATransportation Air Services LLC · Fair Oaks Ranch, TXBuilt 2012 · S/N 614N23DEFreespeed850 LLC · Newburgh, NYBuilt 2016 · S/N 1112N23MYJetka LLC · Rapid City, SDBuilt 2008 · S/N 483N2424XDirect 2 Aviation LLC · Elkhorn, NEBuilt 2002 · S/N 243N242DMHardhill Aviation LLC · Charlotte, NCBuilt 2020 · S/N 1358N243AFAfs LLC · Prairieville, LABuilt 2024 · S/N 1574N243FAfs LLC · Prairieville, LAS/N 1650N247ADOsprey X LLC · New York, NYBuilt 2002 · S/N 247N24MY1024aviation LLC · Odessa, TXBuilt 2016 · S/N 1143N256DXN256dx LLC · Healdsburg, CABuilt 2025 · S/N 1623N258SPAstro Aviation LLC · Birmingham, MIBuilt 2010 · S/N 561N259GMBlue Wing LLC · Nashville, TNBuilt 2011 · S/N 590
Back to AD 2007-03-17 R1