OpenAirDocs.org
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.

N1021N1021 Inc · Wilmington, DEBuilt 1972 · S/N 12016N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735N104DTDavis Brenda Kruszewski · Middleton, IDBuilt 1981 · S/N 96010N108SAFlying A Flight Service LLC · Safford, AZBuilt 1977 · S/N 11416N112EESpur Aviation Services Lc · Twin Falls, IDBuilt 1976 · S/N 11330N114MNSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 1553-107N1187DCordero Miguel · Hollywood, FLS/N 680-626-252N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605N127HJPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11467N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235N1420VCommander Trust LLC · Fort Lauderdale, FLBuilt 1979 · S/N 11524N1525Aviaton Business Corporation · Saint Louis, MOBuilt 1973 · S/N 12022N15CDCommander N15cd LLC · Miami, FLS/N 11177N15SFKolob Canyons Air Services Inc · Wilmington, DEBuilt 1979 · S/N 11528N162ALNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11231N165KMowbray Aviation Inc · Reno, NVBuilt 1963 · S/N 680F-1252-126N167RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 11437N171ATAloft Aviation Services LLC · Spartanburg, SCBuilt 1966 · S/N 1616-49N186EOmeara John S Trustee · Newport Beach, CABuilt 1979 · S/N 11566N192LHHill Lawrence E · Marion, MTS/N 95019N197GBPonderosa Aviation LLC · Safford, AZBuilt 1975 · S/N 11282N198JWGarrison William E · Nickerson, KSBuilt 1962 · S/N 680F-1132-75N199WMJetstream Ltd · Powell, OHBuilt 1964 · S/N 1406-59N20BMKemore Crew Leasing Inc Trustee · Bellingham, WAS/N 1698-75N20MAOberon Management LLC · Fort Smith, ARBuilt 1978 · S/N 11514N2141BAmhurst Development Inc · Lewes, DEBuilt 1978 · S/N 11484N218MSSasha Air LLC · Hingham, MABuilt 1981 · S/N 95041N222MEClearwater Airco LLC · Anchorage, AKS/N 11338N224EZMarjo Ventures Inc · Key West, FLS/N 96206N225MMJ & M Aircraft Holding LLC · Bellaire, TXBuilt 1978 · S/N 11462N225TDCat Air LLC · Melba, IDBuilt 1980 · S/N 11635N231AVTeton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 11353N245CFEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1976 · S/N 11313N24GTPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11254N251ESLumphanan LLC · Adams, NEBuilt 1975 · S/N 11251N25CEKoy Dean R · Houston, TXBuilt 1977 · S/N 11400N2609PNtail LLC · Sheridan, WYBuilt 1979 · S/N 11617N260WEFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11536N267RDReisen LLC · Stevensville, MTBuilt 1978 · S/N 11456N2749GLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1971 · S/N 6047N2750GLo Pilato Family Flights Inc · Wilmington, DEBuilt 1972 · S/N 6059N2755BBoyce Aviation Inc · New Port Richey, FLBuilt 1965 · S/N 1541-105N2755LMerxbauer Terry E · La Pine, ORBuilt 1955 · S/N 680-255N2828SSuburban Air Express Inc · Fairbanks, AKBuilt 1963 · S/N 1329-14N290MPSuburban Air Express Inc · Fairbanks, AKBuilt 1965 · S/N 1535-104N29GADelaurentis Robert Gerard · San Diego, CABuilt 1983 · S/N 15025
Back to AD 2000-02-30