OpenAirDocs.org
AD 2007-06-01 R1

Registered aircraft · 257

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-06-01-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-06-01-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.

N6404DNogle Charles H · Champaign, ILS/N G-124N6450DRosen Gary J · Manchester, MAS/N G-67N6455DFleckenstein David L · Nacogdoches, TXBuilt 1959 · S/N 34-94N659KRocky Mountain Warbirds LLC · Littleton, COBuilt 1955 · S/N G-830N662Whitt Sana F III · East Quogue, NYS/N BG-302N663DBCharles Self Enterprises LLC · Minden, LABuilt 1953 · S/N AF-53-4119N666Cahners Kyle F · Portola Valley, CABuilt 1955 · S/N G-264N66FCIshawooa Air LLC · Cody, WYBuilt 1955 · S/N G-741N6734CClifford Eric S · Paris, TXS/N GM-141N6846CDillon T34 6846c LLC · Scottsdale, AZS/N CCF34-58N6CLRegistration Pending · Phoenix, AZRegistration pendingBuilt 1953 · S/N G-154N6CNNearburg Charles E · Dallas, TXBuilt 1955 · S/N G-736N6KGSelect Aerospace Industries Inc · Weyers Cave, VAS/N BG-250N7071XBlackwell Aviation Inc · Belle Vernon, PABuilt 1955 · S/N BG-36N74010Nogle Charles H · Champaign, ILS/N G-103N74894Arnold Timothy Robert · Longmont, COS/N BG-254N777PPCabana Robert D · Cocoa, FLS/N G-278N7810CTryton Aviation LLC · Reston, VABuilt 1955 · S/N G-767N782Dillon T34 782 LLC · Scottsdale, AZBuilt 1954 · S/N CG58EN7829CNogle Charles H · Champaign, ILBuilt 1949 · S/N G-95N790JWWorkman Properties LLC · Muskegon, MIBuilt 1955 · S/N G-790N7CNMentor Flight LLC · Savoy, ILBuilt 1955 · S/N 52-8272N7VYRegistration Pending · St Louis Park, MNRegistration pendingBuilt 1957 · S/N BG-360N7YSMentor Aviation LLC · Las Vegas, NVBuilt 1957 · S/N BG-389N800ZCelebrate Freedom Foundation · West Columbia, SCBuilt 1957 · S/N BG-388N816DBBaugh Deborah F · Lebanon, TNBuilt 1956 · S/N BG 150N816JBSea Blue Sales & Leasing LLC · Lebanon, TNS/N BG-176N8226EPasqualino Mark W · Ocala, FLS/N BG-379N8228EBrown Robert L · Clovis, CAS/N BG-383N8244EScala Peter M · Port Orange, FLS/N BG-68N8245EWinder Gary W Jr · Thornton, COS/N G-713N8249EFleming Carol A · Torrance, CAS/N BG34N830CBPatterson Ryan R Trustee · Lebanon, OHS/N BG-369N834Hydro Flyers LLC · Woodside, CABuilt 1952 · S/N G-62N845DKJones Curtis R · Burnsville, MNBuilt 1956 · S/N BG-179N84639American Flight Museum · Topeka, KSBuilt 1956 · S/N BG-241N855MCAmerican Flight Museum · Topeka, KSS/N BG-189N861Get Happy Adventures LLC · Leawood, KSBuilt 1965 · S/N G-302N8763KNational Vietnam War Museum · Weatherford, TXBuilt 1957 · S/N BG-393(144086)N88796American Flight Museum · Topeka, KSS/N BG-203N88PFScrump Aero LLC · Oakland, CABuilt 1956 · S/N G772N88PMPrvny Pluk L L C · Houston, TXBuilt 1952 · S/N 34-48N88RMAmerican Airpower Heritage Flying Museum · Dallas, TXS/N G-752N8HXTwin Bridges Aero LLC · Itasca, ILBuilt 1955 · S/N BG-104N9043RNogle Charles H · Champaign, ILS/N G-301N9098RDelta T Properties LLC · Rainbow City, ALS/N G-839N9131RNogle Charles H · Champaign, ILBuilt 1956 · S/N BG-289N9133RWeaver Aircraft Co · Carson City, NVS/N G-802N922PJHaynes Jonathan T · Billings, MTBuilt 1955 · S/N 34-57N93JDDocmax LLC · Tucson, AZBuilt 1956 · S/N G-782
Back to AD 2007-06-01 R1