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.

N4858PGreat Plains Spraying Inc · Colby, KSBuilt 1978 · S/N P21000122N4864YWilliams R E · Fort Walton Beach, FLBuilt 1980 · S/N 21064021N4865PThundersky Farms Inc · Helena, MTBuilt 1978 · S/N P21000124N4867KMark Thomas Productions LLC · Ketchum, IDBuilt 1979 · S/N P21000349N4872KMike Papa LLC · Newton, KSBuilt 1979 · S/N P21000351N4875KHolland Karey Lynn · North Plains, ORBuilt 1979 · S/N P21000353N4876YCarson Engineering And Manufacturing Inc · Springdale, ARBuilt 1980 · S/N 21064025N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026N4880UYanikoski Joseph A · Stoughton, MABuilt 1984 · S/N 21064831N4881U270 W Pearl LLC · Jackson, WYS/N U20605139N4885XEggleston Kevin M · Moore, OKS/N 21060885N4886USkycase Leasing LLC · Wasilla, AKBuilt 1979 · S/N U20605144N4887ZJav Air Services LLC · Anchorage, AKBuilt 1980 · S/N U20606042N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488N4891ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20606044N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033N4896KBraxtal LLC · Kingfisher, OKBuilt 1979 · S/N P21000358N4898CPalo Aerocraft Inc · Salem, VABuilt 1979 · S/N 21063659N48ALHutchinson Scott · Missouri City, TXBuilt 1976 · S/N 21061658N48CFRaven Girl LLC · Eagle River, AKS/N 20700366N48FCSoarmates Inc · Missoula, MTFirst renewal noticeBuilt 1968 · S/N U206-1099N48VAGeiser Corbin · Little Elm, TXBuilt 1977 · S/N 21061798N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N490DBPatkotak Crawford · Barrow, AKS/N U20604472N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N4923UUnited Indian Missions Inc DBA · Tucson, AZS/N U20605164N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N4930NOneill Aviation LLC · Lake Wales, FLBuilt 1977 · S/N 21062421N4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N4939ZStaheli Lee E · Kiana, AKS/N U20606053N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549N4960KShuck Drilling Co · Edgar, NES/N P21000383N4965ADks Air LLC · Owasso, OKS/N P21000827N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386
Back to AD 2002-07-01