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.

N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N613YHKuspuk School District · Aniak, AKBuilt 1980 · S/N 20700633N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047N6148FWorsham Eric S · La Porte, TXS/N 21059048N6151YBulloch Troy P · Cedar City, UTS/N 21064269N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696N6153ZJaars Inc · Waxhaw, NCBuilt 1981 · S/N U20606162N6154NDouer Isaac R · Miami, FLBuilt 1978 · S/N 21062925N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271N61599Freebird Aviation LLC · Eagle, IDBuilt 1974 · S/N U20602350N6160NRj Capital LLC · Mustang, OKBuilt 1978 · S/N 21062931N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932N6163UMcevoy Steven T · Aniak, AKBuilt 1980 · S/N U20605357N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065N6166UBb Aviation LLC · Prescott, AZBuilt 1979 · S/N U20605359N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N6168NRegistered aircraftBuilt 1978 · S/N 21062939N6169FWatrud Joel Carl · Waskish, MNS/N 21059069N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071N6173FLesondank Stephen M · Bellvue, COBuilt 1968 · S/N 21059073N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951N6181ZDittrich James G · Anchorage, AKBuilt 1981 · S/N U20606178N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954N6184CRegistered aircraftBuilt 1979 · S/N 21063824N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705N6195FRegistered aircraftBuilt 1968 · S/N 21059095N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967N6199FAcara Aviation LLC · Portage, MIS/N 21059099N619CHOrion Works Limited · Denali Park, AKBuilt 1969 · S/N U206-1276N61DWZandri Stefano A · Ridgefield, CTS/N U20604257N61PTWings Of Faith Ministries Inc · Tustin, CABuilt 1978 · S/N U20604538N61RBKiazen Black Mountain Holdings LLC · Black Mountain, NCBuilt 1974 · S/N 21060268N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706
Back to AD 2002-07-01