Registered aircraft · 130

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-18-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:79-18-13') 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-18-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:79-18-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.

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-18-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:79-18-13')
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.

N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714 N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648 N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778 N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779 N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735 N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253 N388JCSweetwater Landing LLC · Helena, MTBuilt 1981 · S/N 45568 N3895DMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45590 N38THGlobal Aerials Inc · Pembroke Pines, FLS/N 45653 N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551 N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397 N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081 N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180 N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229 N407CCCounty Of Contra Costa · Martinez, CAFirst renewal noticeBuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026 N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068 N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071 N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005 N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051 N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039 N475ALScotts Helicopter Service Inc · Le Sueur, MNBuilt 1968 · S/N 6675 N477CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1994 · S/N 2045 N478CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1998 · S/N 2053 N480FHFalcon Helicopters Inc · Logan, NMS/N 5009 N480MTCline Air Services LLC · Ellensburg, WABuilt 1994 · S/N 5003 N480RSEuroaviation Inc Trustee · KematenBuilt 1999 · S/N 5038 N480TTSanta Lucia Holding · Forked River, NJBuilt 1997 · S/N 5019 N481RDSchwam Julie R · Hayden, IDS/N 6716 N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321 N5017GHelimontana.Com LLC · Livingston, MTBuilt 1979 · S/N 45228 N513HAMagnum Aviation LLC · Goff, KSBuilt 1977 · S/N 5013 N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162 N520HCValiair Lc Trustee · Casper, WYBuilt 1992 · S/N LN028 N52PLParatus Air DBA · Auburn, INS/N 45744 N535HASummit Helicopters Inc · Salem, VABuilt 1977 · S/N 5035 N543HAMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 5043 N54BLDaumeries Baudouin · Pagosa Springs, COS/N 233 N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770 N55VKBaronanza LLC · Wilmington, DEBuilt 2004 · S/N 1 N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565 N571CJRotorpro LLC · Sevierville, TNBuilt 1983 · S/N 45781 N580DClassic Rotors Museum · Ramona, CABuilt 2000 · S/N 15196 N59410Johnson Helicopter Service Inc · Kuna, IDBuilt 1973 · S/N 6868

Back to AD 79-18-13