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.

N6207HYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700551N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708N6214VRegistered aircraftBuilt 1968 · S/N U206-1189N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718N6243CDcd Aircraft Sales LLC · Leesburg, FLS/N 21063841N6243ZSeattle Seaplanes LLC · Seattle, WABuilt 1981 · S/N U20606199N6246BR L Equipment And Services LLC · Monument, COBuilt 1978 · S/N 21062721N624DRRyan Air Inc · Anchorage, AKBuilt 1979 · S/N 20700517N624ERRyan Air Inc · Anchorage, AKBuilt 1982 · S/N 20700752N624MTJcct Holdings LLC · Plano, TXBuilt 1978 · S/N 210-62913N6255HRenfro Michael W · Bethel, AKS/N 20700452N625KWSchmoker William C · Eden Prairie, MNBuilt 1974 · S/N U20602635N6262KBrz Air LLC · Beaumont, TXBuilt 1979 · S/N P21000395N6266HNovi Inc · Ruby, AKBuilt 1978 · S/N 20700457N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313N626KTRustair Inc · Anchorage, AKS/N U20604426N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851N6271BCountry Flyin Inc · Homestead, FLBuilt 1977 · S/N U20603839N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517N6276BN6276b LLC · Katy, TXS/N 21062730N6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N U20606211N6278YTown & Country Aviation LLC · Sunnyvale, CABuilt 1981 · S/N 21064318N627BTAviation Global Inc · Saint Augustine, FLBuilt 1981 · S/N P21000768N6280PAirborne Equipment Inc · Hendrum, MNBuilt 1979 · S/N P21000159N6282BBig G Air LLC · Durango, COBuilt 1978 · S/N 21062735N6285HWhitetail LLC · Anchorage, AKBuilt 1978 · S/N 20700466N628TTTollen Troy J · Austin, TXBuilt 1978 · S/N 21063058N628YTAdventist World Aviation · Wilson, NCBuilt 1977 · S/N U20603816N6290WLord Of The Wings LLC · Syracuse, NYBuilt 1981 · S/N P21000742N6291CSatl Ranch Aviation LLC · Midland, TXBuilt 1980 · S/N 21063857N6294PMarkowich Darren K · Gilbert, AZBuilt 1978 · S/N P21000163N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322N6297HHackbart Gary H · Las Vegas, NVBuilt 1978 · S/N 20700472N6297YL&L Aviation LLC · Baden, PAS/N 21064323N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858N6299PDanlars Aircraft Sales · Mccall, IDBuilt 1978 · S/N P21000165N629WSPrecision Avionics Specialists · Griffin, GABuilt 1970 · S/N 21059363N62SK55x LLC · Kalispell, MTS/N P21000096N6300PSchrempp Aviation LLC · Winnemucca, NVBuilt 1978 · S/N P21000166
Back to AD 2002-07-01