AD 2000-02-30

Registered aircraft · 270

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:2000-02-30')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-02-30')
  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.

N29GDAriel Seafoods Aviation LLC · Destin, FLBuilt 1983 · S/N 15035N29PRGa Flying LLC · Kalispell, MTBuilt 1969 · S/N 6018N30854Cornerstone Financial Enterprises LLC · Mesquite, NVS/N 11229N309VSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 1659-128N31BVCourtney Aviation LLC · Columbia, CAS/N 11315N32ALAero Air LLC · Hillsboro, ORBuilt 1976 · S/N 11336N32GASpur Aviation Services Lc · Twin Falls, IDBuilt 1974 · S/N 11215N32WSPonderosa Aviation LLC · Safford, AZBuilt 1976 · S/N 11339N333UPEverel Airborne LLC · Sandia Park, NMS/N 96015N3341Klitzke Lucanus E · La Plata, NMBuilt 1956 · S/N 680-456-126N362SHFlight-Plan One LLC · Bay City, MIBuilt 1976 · S/N 11316N364WAAerokinetical Aviators LLC · West Chester, OHBuilt 1977 · S/N 11439N368TPDonohue Andrew · Tulsa, OKBuilt 1973 · S/N 12039N36JFMmdex LLC · Carlisle, PABuilt 1978 · S/N 11478N36JTAerial Surveys International LLC · Watkins, COBuilt 1980 · S/N 95-024N37SBZb Investments Ltd · Dallas, TXS/N 11724N383HCAc690 LLC · Alpine, WYBuilt 1975 · S/N 11310N385CGOwensboro Warehouse Leasing LLC · Owensboro, KYBuilt 1965 · S/N 1495-14N3869FElkhorn Aviation Inc · Baker City, ORBuilt 1973 · S/N 11141N38LMKoy Dean · Houston, TXBuilt 1977 · S/N 11424N38WAAirborne Support Inc · Houma, LABuilt 1974 · S/N 11169N3NTSpur Aviation Services Lc · Twin Falls, IDBuilt 1983 · S/N 15037N400DSSpur Aviation Services Lc · Twin Falls, IDBuilt 1978 · S/N 11512N401MGLeff William J · Dayton, OHBuilt 1965 · S/N 1527-29N40SMCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1979 · S/N 11559N410THHardy Hole Drilling LLC · El Paso, TXS/N 1790-20N411WRForbes Greg · Placerville, CAS/N 1505-19N414CUnited Trading Unlimited LLC · Princeton, NJS/N 12021N420LWCrazy Horse LLC · Princeton, WVS/N 11455N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519N4278SChagnot Catherine J · Athens, OHBuilt 1959 · S/N 680E-813-60N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006N449LCTj Air Holdings Inc Trustee · Wilmington, DES/N 11187N44NCPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11387N45AZPonderosa Aviation LLC · Safford, AZBuilt 1977 · S/N 11383N4622EMontana Department Of Highways · Helena, MTBuilt 1968 · S/N 1723-3N4717VCourtney Aviation LLC · Columbia, CAS/N 11220N479PTT Enterprises Inc · Jackson, MSBuilt 1981 · S/N 96011N47EPRum Bum Distributors Inc · Miami, FLBuilt 1978 · S/N 11520N47TTLon Air LLC · Miles City, MTBuilt 1979 · S/N 11600N480KSpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11543N48BANjia Air LLC · Montgomery, INS/N 11665N5016HBest Aircraft Deals LLC · Salt Lake City, UTS/N 11452N5035ESuburban Air Express Inc · Fairbanks, AKBuilt 1968 · S/N 1764-147N50DXYada Yada Yada Inc DBA · Fresno, CABuilt 1974 · S/N 11227N512JDOntrac Air Service Inc · Springfield, ORS/N 1584-36N515AMAllen Myland Inc · Media, PABuilt 1980 · S/N 95008N51DMJersey Ordnance Inc · Westampton, NJBuilt 1981 · S/N 96014N51WFD&S Aircraft LLC · Gainesville, GABuilt 1981 · S/N 11684N526WYSteelesky Ltd · Maineville, OHBuilt 1971 · S/N 6051
Back to AD 2000-02-30