AD 2002-07-01

Registered aircraft · 3,466

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:2002-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
  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.

N8474UBirdwin LLC · Buras, LABuilt 1969 · S/N U2061294N8475MSpess Drilling Co Inc · Cleveland, OKBuilt 1977 · S/N 21062046N84777Flight Path Partners LLC · San Mateo, CABuilt 1972 · S/N 21059624N8477QShoshone Aviation Services LLC · Missoula, MTBuilt 1976 · S/N U20603335N8479QLake Airways Management LLC · Hazelhurst, WIBuilt 1976 · S/N U20603337N8482QGregg Flying Service Inc · Durango, COBuilt 1976 · S/N U20603340N8491QDry Bay Holdings LLC · Yakutat, AKBuilt 1976 · S/N U20603349N8495MCourtney Aviation LLC · Columbia, CAS/N 21062048N8496QWord Forrest R Trustee · New Braunfels, TXBuilt 1976 · S/N U20603354N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867N8506QBell Robert C · Colby, KSS/N U20603363N8514QAvila Robert A · Lawrence, MABuilt 1976 · S/N U20603371N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081N8546QBlack Andrew J · Broomfield, COBuilt 1976 · S/N U20603402N8560QLunati Ralph · Mc Alpin, FLBuilt 1976 · S/N U20603416N8564QEnvii Aviation LLC · Monroe, WABuilt 1976 · S/N U20603420N8570QTwo O Six Inc · Fort Myers, FLBuilt 1976 · S/N U20603426N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277N858JAAms Aviation LLC · South Bend, INBuilt 1976 · S/N U20603437N8592QSkyview Aviation Holdings LLC · The Hills, TXBuilt 1976 · S/N U20603448N8594QParkerson Stan L · Fairbanks, AKBuilt 1976 · S/N U20603450N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453N8599QForbes Paul J · Anchorage, AKBuilt 1976 · S/N U20603454N859ALAms Aviation LLC · South Bend, INBuilt 1979 · S/N U206-04888N85ADEagle Eye Produce Inc · Idaho Falls, IDS/N P21000795N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774N8623ZHauze John W · San Antonio, TXBuilt 1967 · S/N P206-0423N8628ZSaddler Susan J · Dayton, OHBuilt 1967 · S/N P206-0428N8630ZAlaska Village Missions · Homer, AKBuilt 1967 · S/N P206-0430N8632ZTate Roger · Redlands, CAS/N P206-0432N8635ZLipper Stephen W · Griffin, GAFirst renewal noticeBuilt 1967 · S/N P206-0435N8638ZEichman David A · Topeka, KSBuilt 1967 · S/N P206-0438N8643ZVitatoe Industries Inc · Chillicothe, OHBuilt 1967 · S/N P206-0443N8644ZMasters Mission · Nenana, AKBuilt 1967 · S/N P206-0444N8646QPoe Asphalt Paving Inc · Lewiston, IDBuilt 1976 · S/N U20603462N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463N8650ZBarry Russell L · Fort Mohave, AZBuilt 1967 · S/N P206-0450N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474N8686QWaters & Associates Inc · Bellaire, TXS/N U20603468N8688ZPowell Leo · Villa Park, CAS/N P206-0488N8699ZEdaero LLC · Bangor, MEBuilt 1968 · S/N P206-0499N86AGGarlow Terry J · Granbury, TXBuilt 1975 · S/N 21060966N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N8703ZLynch Cody Ryan · Galveston, TXBuilt 1968 · S/N P206-0503N8704ZHunt David H · Ortonville, MIBuilt 1968 · S/N P206-0504
Back to AD 2002-07-01