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.

N34EMSpirit Rotorcraft LLC · Phoenix, AZBuilt 1955 · S/N 53-4150N34EPSkogen James C · Blue Earth, MNS/N G-74N34EVSilva Alexander J · Holly Springs, NCS/N G-16N34FUWatson George E · Temecula, CABuilt 1956 · S/N BG-180N34KJWright Wing Aviation LLC · Pittsboro, NCBuilt 1961 · S/N G-715N34KRH & H Air Inc · Washington, INBuilt 1956 · S/N G-766N34MKBadger Industries LLC · Harvard, ILBuilt 1953 · S/N G-88N34MLDelta Ent Leasing Llp · Brighton, COS/N G-719N34MRN34mr LLC · Orlando, FLBuilt 1952 · S/N G-39N34MTPerigee Investments LLC · Anacortes, WAS/N BG-417N34MXEwald Robert H · Red Lodge, MTBuilt 1984 · S/N PG-114N34PACosentino William D · Lees Summit, MOBuilt 1955 · S/N G-268N34SYGeneral Aviation Modifications Inc · Ada, OKBuilt 1956 · S/N BG-246N34SZWhitt Ronald D · Slinger, WIBuilt 1953 · S/N 53-4120N34TXMccormack Robert · Reno, NVS/N G-796N34VBBarrett Victor L · Sevierville, TNS/N BG-361N34VMRoberts Glenn T · Port Orange, FLBuilt 1954 · S/N G-98N34VWGalloway Chris · Jordan Valley, ORS/N G-80N34VYTrident Aircraft Inc · Easton, MDBuilt 1955 · S/N BG-41N34XAVectored Solutions Inc · Everett, WABuilt 1945 · S/N G-799N34XXBallance Harry Greene Jr · Atlanta, GAS/N BG-54N357WMMentor Partners Inc · Springfield, ILBuilt 1960 · S/N BG-357N36AESokolowski Daniel J · Clear Lake, IAS/N G-77N3789GMentor 89g LLC · Kalispell, MTS/N G-737N3792GNogle Charles H · Champaign, ILS/N G-770N3799GRounds Chris · Waller, TXS/N G-709N382TTWill Rittner · Sevierville, TNS/N G-143N3932ASims Douglas · Naples, FLBuilt 1953 · S/N 53-4117AN3CNCheck Six LLC · Champaign, ILBuilt 1981 · S/N BG-198N3VYSilverstein Adam R · Pittstown, NJBuilt 1957 · S/N BG-334N4002FDoyle Patrick T · Fond Du Lac, WIBuilt 1955 · S/N G-779N400LLMentor Flyers Inc · Paragon, INBuilt 1957 · S/N BG-400N400MTSpevco Inc · Pfafftown, NCBuilt 1955 · S/N G-145N400YCTuca 27 LLC · Lewes, DES/N G-128N4028EAmerican Airpower Museum · Farmingdale, NYBuilt 1956 · S/N BG-292N4028GUnited States Navy (Owner) · Millington, TNBuilt 1955 · S/N BG-9N4084Dailey Garrett C · Alamo, CABuilt 1960 · S/N BG-391N4170Nogle Charles J · Champaign, ILBuilt 1964 · S/N G-270N4178AObrien Michael J · San Juan Capo, CABuilt 1952 · S/N G-20N41DCDc Aircraft LLC · Shreveport, LABuilt 1953 · S/N G-106N41TCMentor Flight LLC · Mercer Island, WABuilt 1954 · S/N CG-73N4213ZFarmer Aviation LLC · Milan, MIBuilt 1955 · S/N BG-112N4218ARed Skye 52 LLC · Port Orange, FLS/N 52-8271AN421NMWings Over The Rockies Air & Space Museum · Denver, COBuilt 1961 · S/N G-720N422MNNogle & Black Aviation Inc · Champaign, ILS/N G833N422NMRhyne Gregory L · Port Orange, FLS/N 52-8265N424NMSky West Aviation Inc Trustee · Albuquerque, NMS/N BG-59N4295ANy Fighter Jets · Wilmington, DES/N G-755N434JHCloud 9 Wings LLC · Webberville, MIS/N 53-4148N44007Parrish Rob G · Columbus, TXBuilt 1953 · S/N G-126
Back to AD 2007-06-01 R1