OpenAirDocs.org
AD 76-18-07

Registered aircraft · 40

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010N12FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 016N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037N24SAClark Lloyd E · Hanover, MDS/N 24-117N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101N26FNDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 011N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123N31HKN31hk Inc · Miami, FLBuilt 1975 · S/N 016N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062N35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 010N361PJPremier Jets Inc · Hillsboro, ORBuilt 1974 · S/N 003N362PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N 017N364CLLacy Clay Trustee · Los Angeles, CABuilt 1981 · S/N 383N382TCSkylink Jets Inc · Fort Lauderdale, FLS/N 039N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006N435MSPuragain Water LLC · Escondido, CAS/N 054N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104N473TCTulsa Technology Center School District #18 · Tulsa, OKBuilt 1969 · S/N 043N524PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 033N547PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 012N54PAVpc Planes LLC · Wilmington, DEBuilt 1974 · S/N 004N564CLDavid Copperfield Project Magic Fund · Las Vegas, NVBuilt 1976 · S/N 25-060N635RJRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 35-017N68LULewis University · Romeoville, ILBuilt 1968 · S/N 163N711CWPremier Jets Inc · Hillsboro, ORBuilt 1965 · S/N 055N71PGPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 013N80PGPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 063N83FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 007N84FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 002N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590N905CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 005N913CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 013N91GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 032N929JGPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 035
Back to AD 76-18-07