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.

N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236N4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeBuilt 1979 · S/N U20605513N4616CSan Angelo Aero L L C · San Angelo, TXS/N 21063576N4617CBrookhaven Corp · Buffalo, NYS/N 21063577N4617WSavoldelli Steven · Los Angeles, CABuilt 1980 · S/N P21000623N4620YCenturion Travel LLC · Fort Worth, TXBuilt 1980 · S/N 21063960N4621QFitzgerald Barry Eugene · Springfield, ILBuilt 1971 · S/N 21059521N4622QBas Part Sales LLC · Greeley, COS/N 21059522N4624KHoyt Matthew P · Newport Beach, CABuilt 1979 · S/N P21000243N4624QBowen Kennith M II Trustee · Winters, CABuilt 1971 · S/N 21059524N4625QBank Of Utah Trustee · Salt Lake City, UTBuilt 1971 · S/N 21059525N4626KWyeth Patrick B Trustee · Chino Valley, AZBuilt 1979 · S/N P21000244N4627KIsbell Brian · Rosenberg, TXBuilt 1979 · S/N P21000245N4627QMassey Larry A · New Braunfels, TXBuilt 1971 · S/N 21059527N4629KAuburn Farms LLC · Auburn, KSBuilt 1979 · S/N P21000247N4631CGraves Martin · Odessa, TXBuilt 1979 · S/N 21063582N4634U4634u LLC · Taylor, AZS/N U20605015N4636KAdvanced Database Designs LLC · San Ramon, CABuilt 1979 · S/N P21000248N4637UWright Air Service Inc · Fairbanks, AKBuilt 1979 · S/N U20605017N4639QGrundmann Karl · Manassas, VABuilt 1971 · S/N 21059539N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812N4648CMadhvani Sanjay J · Tucson, AZBuilt 1979 · S/N 21063583N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744N4651TUnited Indian Missions Inc DBA · Tucson, AZBuilt 1979 · S/N U20605255N4653Q53 Quebec LLC · El Dorado, CABuilt 1972 · S/N 21059553N4654QStapleton Mark Christopher · Vestavia Hills, ALBuilt 1972 · S/N 21059554N4656KValley Agriculture LLC · Galt, CABuilt 1979 · S/N P21000251N465AMN465am LLC · Hollis, NHBuilt 1981 · S/N 21064613N4660CToudouze John M · La Vernia, TXS/N 21063584N4661ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20605998N4665CKrissman Ryan · Gallup, NMBuilt 1977 · S/N U20603841N4671KNifong Robert B · Jacksonville, FLS/N P21000255N4672KMartin Richard E Trustee · Colorado Springs, COBuilt 1979 · S/N P21000256N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814N4682QHangar 27 LLC · Bountiful, UTS/N 21059582N4689QJohnson Tod W · Three Rivers, CABuilt 1972 · S/N 21059589N468MSSturdivant Mike P Jr · Glendora, MSBuilt 1980 · S/N 21063969N4690UKim Hansen Co · Burley, IDBuilt 1979 · S/N U20605059N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816N46CSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N P21000413
Back to AD 2002-07-01