Skip to content

Registered aircraft · 44

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

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:79-05-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:79-05-07') ORDER BY n_number

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:79-05-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:79-05-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.

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:79-05-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:79-05-07')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N17SQL R & T LLC · Midlothian, TXBuilt 1978 · S/N GA7-0017 N300EDKv Helicopters LLC · Lititz, PAS/N GA7-0098 N37DKPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0030 N384MAKnoxville Aviation LLC · Lenoir City, TNBuilt 1978 · S/N GA7-0054 N38GEFlorida Captain Services LLC · Punta Gorda, FLBuilt 1978 · S/N GA7-0038 N412FXCougar Aircraft Corp · Cheyenne, WYBuilt 1978 · S/N GA70035 N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110 N51AWPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0053 N51EHHolmgren Elizabeth · Pittsburgh, PAS/N GA70051 N5GJNorthampton Lsa LLC · Northampton, MABuilt 1978 · S/N GA7-0006 N60MRHansen Charles R · Covington, TNBuilt 1978 · S/N GA-7-0060 N619ABAvenge Holdings LLC · Ashburn, VABuilt 1978 · S/N GA7-0068 N6ETSumner Gary · Knoxville, TNBuilt 1978 · S/N GA7-0004 N707GAMorris David S · Henderson, NVBuilt 1978 · S/N GA7-0007 N713GAMustang Sally Aviation LLC · Camden, SCBuilt 1978 · S/N GA7-0014 N722GACougar Ga-7 LLC · Helena, MTBuilt 1978 · S/N GA70020 N723GALong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N GA7-0021 N724GAWilliams John D · Geneva, OHS/N GA7-0023 N725GALendor David A · Jersey City, NJBuilt 1978 · S/N GA7-0024 N726GASouth Texas Air Force LLC · Mission, TXBuilt 1978 · S/N GA7-0025 N727GAPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0026 N729GMorrison Brian D · Albuquerque, NMS/N GA7-0100 N729GABradley Mark S · Holly, MIBuilt 1978 · S/N GA7-0028 N738GTj Air Holdings Inc Trutee · Wilmington, DEBuilt 1979 · S/N GA7-0106 N743GACougar Management Inc · Ridgeland, MSBuilt 1977 · S/N GA7-0031 N754GAQuest Technical Sales And Marketing Inc · Camarillo, CAS/N GA7-0045 N755GAGadis Anthony J · Etiwanda, CAS/N GA7-0046 N763WASumner Gary · Knoxville, TNBuilt 1978 · S/N GA7-0050 N768GASumner Gary · Knoxville, TNBuilt 1978 · S/N GA7-0055 N769GALong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N GA7-0056 N774GAAircraft Resource Center Inc · Lakeville, MNBuilt 1978 · S/N GA7-0061 N775GACougar Leasing LLC · Everett, WABuilt 1978 · S/N GA7-0062 N776GAHinds Community College · Raymond, MSBuilt 1978 · S/N GA7-0065 N778JNBialek Joseph · New Smyrna Beach, FLBuilt 1978 · S/N GA7-0043 N780GAPrairie Planes LLC · Mitchell, SDBuilt 1978 · S/N GA7-0067 N784GAMr Dent Inc · Manheim, PAS/N GA7-0071 N785GASterling Thelma R · Bridge City, TXS/N GA7-0072 N786GAStar Child II LLC · Brooklyn, NYS/N GA7-0073 N787GADarling Robert Trustee · Henderson, NVS/N GA7-0075 N78HSEight Hotel Sierra LLC · Port Charlotte, FLS/N GA7-0069 N795GADeruggiero Michael W · Middle River, MDBuilt 1979 · S/N GA7-0085 N797GAN797ga LLC · Manassas, VAS/N GA7-0087 N799GAC And M Enterprises Inc · Augusta, MES/N GA7-0090 N887CCMr Dent Inc · Manheim, PABuilt 1978 · S/N GA7-0044

Back to AD 79-05-07