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.

N294DTrant David B · Kingsville, TXBuilt 1977 · S/N P-451N299KAir Transport LLC · Troy, MTBuilt 1979 · S/N TJ-185N29CCSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-117N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414N2ASSupkis Daniel E Jr · Houston, TXBuilt 1979 · S/N P-511N2GPPlanes Of Fame Air Museum · Chino, CAS/N P-56N2JEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N P-358N3036WSpowart James F DBA · Huntington Beach, CABuilt 1973 · S/N P-236N3055WChaney George · Hazard, KYS/N P-251N306QCAmerican Woodcraft LLC · Labelle, FLBuilt 1972 · S/N P-190N30K9g LLC · Centerville, TNBuilt 1973 · S/N P-255N30LLSoftware Innovations LLC · Wahoo, NEBuilt 1982 · S/N TJ-391N30MMHilton Heli LLC · Wilmington, DEBuilt 1979 · S/N P-507N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N311ANValiair Ltd Co Trustee · Casper, WYBuilt 1970 · S/N P-141N311NSimmons Calvin L · Peralta, NMBuilt 1970 · S/N P-130N316EWhiskey Papa LLC · Denver, COS/N P-550N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278N322RJAero-Mobil Inc · Wilmington, DEBuilt 1974 · S/N P-322N323PWWiseman Aviation Inc · Flagstaff, AZBuilt 1980 · S/N P-541N326TCAlvarado Ruben Jr · Brownsville, TXBuilt 1969 · S/N P-121N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N3344DBoyd David S · Brooklyn Park, MNBuilt 1975 · S/N P-344N335DLarson Ken · Lake Havasu City, AZS/N P-129N33PMKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1977 · S/N TJ-78N33WFReardon Randy L · Sedalia, COBuilt 1971 · S/N P-168N33WKSager Earl Dwayne · Perryton, TXBuilt 1979 · S/N TJ-243N341DSl Jet D LLC · Harrison, TNBuilt 1976 · S/N P-397N3456AEl Aviation LLC · Alpena, MIBuilt 1977 · S/N P-443N345CGHargis James L · Tioga, TXBuilt 1984 · S/N TJ-468N345YWImpact Real Estate Group LLC · Casper, WYBuilt 1969 · S/N P-85N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N358PBN358pb LLC · Amarillo, TXBuilt 1977 · S/N TJ-90N360AKLindquist Scott DBA · Minnetonka, MNBuilt 1968 · S/N P-18N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3669DCvf Aviation LLC · Paoli, INS/N P-544N3675DS & L Air LLC · Torrington, WYBuilt 1980 · S/N P-546N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298N368BWYarak Six LLC · Berkeley, CAFirst renewal noticeBuilt 1974 · S/N P-290N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306N3694DAircraft & Interiors @ Klns Ltd · Brownstown, PAExpired dealer, pending cancellationBuilt 1980 · S/N P-552N3696LP51d Mustang LLC · Bigfork, MTBuilt 1980 · S/N TJ-310N36EB42 North Systems Aviation LLC · Hingham, MABuilt 1984 · S/N TJ-465N3707XDe Anza Building & Maintenance Inc · Los Altos, CABuilt 1980 · S/N P-557N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N379JRDanny Skaggs Co Inc · San Antonio, TXBuilt 1984 · S/N TJ-447N379LV379lv LLC · Broomfield, COBuilt 1982 · S/N TJ423N37DBCentral Virginia Aviation Inc · Petersburg, VABuilt 1974 · S/N P-309
Back to AD 2002-10-13