OpenAirDocs.org
AD 2002-10-13

Registered aircraft · 562

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-10-13')
    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-10-13')
  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.

N454BMajeste Air LLC · Loveland, COS/N P-302N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4567MCassinelli Steven W · Sacramento, CABuilt 1978 · S/N P-467N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4618MBedrock Siteworks LLC · Coatesville, PABuilt 1978 · S/N TJ-150N463LSilver Development & Associates Inc · Ojai, CABuilt 1978 · S/N P-463N4675MRivas Paul S · Boulder City, NVS/N P-475N4762MSan Bernardino Community College District · San Bernardino, CAFirst renewal noticeBuilt 1978 · S/N P-462N47BMDuke Aircraft LLC · Philipsburg, MTBuilt 1976 · S/N P-408N47USTurner Aero LLC · Amelia Island, FLBuilt 1980 · S/N P-543N48GCRoyal Air Inc · Shreveport, LABuilt 1970 · S/N P167N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N493DVSatterfield Thomas J · Ewing, ILBuilt 1979 · S/N TJ-218N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N49AMXsurgo LLC · Brentwood, TNBuilt 1976 · S/N P-406N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26N505GEWgm Solutions LLC · Mart, TXBuilt 1971 · S/N P-186N505JMAndriopulos Salguero Inc · Hialeah, FLBuilt 1979 · S/N P-493N5073MMajeste Air LLC · Loveland, COBuilt 1978 · S/N P-473N507TTCampo Feliz Aircraft Services LLC · Miami Lakes, FLS/N P-558N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217N512SLSalmon Raymond A Trustee · Tavares, FLBuilt 1984 · S/N TJ-472N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N518YPWs Aviation Group LLC · Washta, IABuilt 1980 · S/N TJ-265N519CMCygnet Aerospace Corp · Los Osos, CAS/N TJ-56N51ALGalaxy Cerne LLC · Burlington, VTBuilt 1973 · S/N P-247N51CLDocs Flight Training LLC · Prescott, AZBuilt 1974 · S/N P-260N51KPShoreline Aviation LLC · Waco, TXS/N P-368N523EFAircraft Partner Holdings Inc Trustee · BerlinBuilt 1979 · S/N P-523N523HCN523hc LLC · Pinecrest, FLBuilt 1972 · S/N P-200N525GATechnical And Aviation Services LLC · Salisbury, NCBuilt 1979 · S/N P-525N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274N531ABMissionair Inc · Danbury, CTS/N TJ-454N53AJG Bongard LLC · Fort Myers, FLBuilt 1977 · S/N P-444N5466RNorthwest Turbine LLC · Spokane, WABuilt 1985 · S/N TJ-497N54DBMattingly Aviation LLC · Radcliff, KYBuilt 1970 · S/N P-127N5558PValiair Lc Trustee · Casper, WYS/N TJ-399N555CSGibson Air LLC · Park Hills, MOS/N TJ-385N557PAPlatinum Leasing LLC · Fate, TXBuilt 1981 · S/N P-580N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421N55CLBoyd Larry C · Seymour, TXBuilt 1969 · S/N P-77N55VVMcnitt Todd M · Newport, ORBuilt 1968 · S/N P-20N55ZMAngel V LLC · Gig Harbor, WABuilt 1977 · S/N P-437
Back to AD 2002-10-13