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.

N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705N5107WRugger Investment Group LLC · Sheridan, WYBuilt 1981 · S/N P21000640N5108QPardue William C Jr · Leesville, LABuilt 1975 · S/N U20603060N5109QRmcb LLC · Kalispell, MTBuilt 1972 · S/N 21059609N510AASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064699N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140N5114QJ&A Air · Richfield, UTS/N 21059614N5119XMission Aviation Fellowship · Nampa, IDBuilt 1980 · S/N U20605571N5119YWby Aviation LLC · Lewes, DES/N 21064083N511RLHatch Leasing Co LLC · Marble Canyon, AZBuilt 1973 · S/N U20602109N5120VTreaster Implement Co Inc · Beloit, KSBuilt 1975 · S/N 21060839N5120XZimmerman Tom V · North Pole, AKBuilt 1980 · S/N U20605572N5122QPyxis LLC · Cheyenne, WYBuilt 1972 · S/N 21059622N51237Infanger James Robert · Salmon, IDS/N U20601983N5124WBest Life Aviation LLC · Cedar Park, TXBuilt 1981 · S/N P21000642N5127QRegistered aircraftBuilt 1972 · S/N 21059627N512ATRanch Aero LLC · Sterling City, TXBuilt 1975 · S/N 21060721N512GTBarron Thomas Aviation Inc · Scottsdale, AZBuilt 1974 · S/N 21060178N512SBN512sb LLC · Austin, TXBuilt 1981 · S/N P21000762N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631N5134WPlane Fun Inc Tr Trustee · Snellville, GAS/N P21000643N5139QNykerk Kory · San Miguel, CABuilt 1972 · S/N 21059639N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851N5146QJ&G Aero Investments Group LLC · Wilmington, DEBuilt 1972 · S/N 21059646N5146WN5146w LLC · Willow Spring, NCS/N P21000645N514TPactolus Investments LLC · Blounts Creek, NCBuilt 1980 · S/N U20605940N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292N515HE2f Trade LLC · Gainesville, TXS/N 21061457N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5171VLisenbey Edward · Caldwell, IDS/N 21060846N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518MJPursuit 53 · College Station, TXBuilt 1981 · S/N U20606535N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N5194TBrown Helicopter Inc · Pensacola, FLS/N U206-06660N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304N5198VMaddock Jay B · Sugar Grove, ILS/N 21060859N51AKSchroth Charles D DBA · Gustavus, AKS/N U20603785N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602N51CMCorley W Michael · Mc Minnville, TNBuilt 1972 · S/N 21059628
Back to AD 2002-07-01