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.

N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141N59210Safe Pilots Group LLC · Nyack, NYBuilt 1973 · S/N 21060161N59237Boland Matthew S · Anchorage, AKBuilt 1974 · S/N U20602637N59240Banegas Jose Carlos Zankiz · Flint, TXBuilt 1974 · S/N 21060174N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928N59292Cloud Busters LLC · Goodrich, MIBuilt 1974 · S/N 21060196N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645N59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 21060199N592KBCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601770N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949N5952FRedmon David M · Biloxi, MSBuilt 1967 · S/N 21058952N5953FKnickerbocker Thomas C · Houston, TXS/N 21058953N5956XCox David F · Tucson, AZS/N 21058956N595LTN595lt LLC · Edwards, COS/N P21000008N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969N5982FCharles James Brown · Littlefield, TXS/N 21058982N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996N5998FMedic Choppers LLC · Springdale, ARS/N 21058998N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711N5GAActon Steve · Reno, NVS/N P21000189N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875N600NUN600nu LLC · New Meadows, IDBuilt 1977 · S/N U20603976N600WLMoore Stan D · Amarillo, TXBuilt 1979 · S/N P21000409N60134Smith Eddie D · Wasilla, AKBuilt 1973 · S/N U20602011N6013BFrost Sean D · Lovell, WYS/N 21062664N6020NWatts Carl · Thousand Oaks, CABuilt 1978 · S/N 21062888N6026NWildcat Flying Service Inc · Lakeland, FLS/N 21062894N6028NBernhard Mark J · Alamo, CABuilt 1978 · S/N 21062896N602LTKincaid James B · Hamilton, MTS/N U20605798N602YMSawtooth Aviation Resources LLC · Ketchum, IDBuilt 1981 · S/N U20606231N6032NHqgt210 LLC · Hugoton, KSBuilt 1978 · S/N 21062900N6035NAce Arrow LLC · Reno, NVBuilt 1978 · S/N 21062903N6036NMorales Juan · Addison, TXBuilt 1978 · S/N 21062904N6037BDel Mar Aviation Inc · Wilmington, DEBuilt 1978 · S/N 21062667N6038BHaarmeyer Air LLC · Lovington, NMBuilt 1978 · S/N 21062668N6039NTwin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 21062907N603ETSanborn Map Co · Colorado Springs, COBuilt 1973 · S/N U20602230N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916
Back to AD 2002-07-01