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.

N3804MGlenmont Air LLC · Strasburg, VABuilt 1981 · S/N TJ-328N3807TAmbrose Construction Ltd · Corpus Christi, TXBuilt 1980 · S/N TJ-332N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341N3848YBaron Lake LLC · Jefferson, LABuilt 1981 · S/N TJ-349N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355N3876CSoar International LLC · Olive Branch, MSBuilt 1979 · S/N P-513N38NHendrix Stuart Brent Trustee · Atascadero, CABuilt 1973 · S/N P-220N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N395KBBunn Mary · Williamstown, WVBuilt 1982 · S/N P-592N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207N3984Epstein Steven D · Vallejo, CABuilt 1970 · S/N P-147N399TLWilson Aircraft Inc · Independence, MORegistration revokedBuilt 1969 · S/N P-54N39PJMeister Kurt · Mesa, AZBuilt 1979 · S/N P-514N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N400BPCole Gary · Richmond, TXBuilt 1969 · S/N P-96N402JSShelco Investments LLC · Las Vegas, NVBuilt 1971 · S/N P175N4071SDuke Boys LLC · North Sioux City, SDBuilt 1975 · S/N P-324N408FAGregory Carrillo Inc · Glendale, AZBuilt 1977 · S/N P-434N40DDReceptacle Ministries · Blackshear, GABuilt 1973 · S/N P-239N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N410GBeechcraft Heritage Museum · Tullahoma, TNBuilt 1982 · S/N P-596N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4141SAftab Younus · Pleasanton, CAS/N P-319N41CFJet Movers LLC · Vandalia, ILS/N TJ-47N41STGavilan College Foundation · Gilroy, CABuilt 1975 · S/N P-340N420ASBas Part Sales LLC · Greeley, COS/N P-265N420JDDuke LLC · Reno, NVS/N P-521N422SBHudak Christopher · South Miami, FLBuilt 1978 · S/N P-479N4277SDfj Transportation LLC · Ridgedale, MOFirst renewal noticeBuilt 1977 · S/N P-403N42ADLopez Michael · Leesville, LAS/N P-283N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109N4329WRiders Up LLC · Hale Center, TXBuilt 1974 · S/N P-263N4369WLeonesa LLC · LeonS/N P-298N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479N43HDEastern Shore Aviation LLC · Lebanon, PAFirst renewal noticeBuilt 1970 · S/N P-149N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N440CP929 Aviation LLC · Shreveport, LABuilt 1975 · S/N P-373N4420WOdonata LLC · Lewiston, IDBuilt 1974 · S/N P-268N4445WHendrix Todd M · Bakersfield, CABuilt 1973 · S/N P-245N4448FAviation Machine Products · Northridge, CABuilt 1976 · S/N P-396N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58N44SAGniks LLC · Nevada, MOBuilt 1978 · S/N TJ-167N44WReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N P-29N44XJRegistered aircraftBuilt 1984 · S/N TJ-478N4535SWintson James R · Cornelius, NCBuilt 1976 · S/N P-384N4547SLorentz Aviation LLC · Canadian, TXBuilt 1976 · S/N TJ-81
Back to AD 2002-10-13