OpenAirDocs.org
AD 79-21-01 R1

Registered aircraft · 1,074

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:79-21-01-R1')
    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-21-01-R1')
  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.

N55UPAlba Leasing Services LLC · Scottsdale, AZBuilt 1983 · S/N 3750N55VKBaronanza LLC · Wilmington, DEBuilt 2004 · S/N 1N56ALBoard Of County Commissioners · Bartow, FLBuilt 1974 · S/N 1402N56BLHelicopters Inc · Cahokia, ILBuilt 1982 · S/N 3502N571HHHlh Leasing LLC · Wilmington, DEBuilt 1977 · S/N 470125DN572SABank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 0252EN5733KEcolift Corp · San Juan, PRS/N 2951N5743GBcww LLC · Bakersfield, CABuilt 1981 · S/N 6070N5743HAspen Ag Helicopters Inc · Oxnard, CABuilt 1980 · S/N 3042N5750TScotts Helicopter Service · Le Sueur, MNBuilt 1980 · S/N 3095N57EFCk Helicopters LLC · Jasper, INBuilt 1971 · S/N 660N58003San Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 1020N580DClassic Rotors Museum · Ramona, CABuilt 2000 · S/N 15196N581LRBurkeen Jeffrey D · Doniphan, MOBuilt 1971 · S/N 71-20565N581SCShelby County Sheriffs Office · Columbiana, ALBuilt 1995 · S/N 5201N58251Windward Aviation Inc · Puunene, HIBuilt 1978 · S/N 880317DN582RAMarks Assets Group LLC · Lafayette, LABuilt 1979 · S/N 3582N58765State Of Montana · Helena, MTBuilt 2001 · S/N 5276N58JRIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1986 · S/N 7361N58XMS-Tec Corporation DBA · Mineral Wells, TXBuilt 1971 · S/N 71-20810N59410Johnson Helicopter Service Inc · Kuna, IDBuilt 1973 · S/N 6868N59427Ambrosini Helicopters Inc · Fresno, CAS/N 1132N594DBDeland Air And Sea Brokerage Inc · Deland, FLBuilt 1982 · S/N 1169DN59548Hendrickson Flying Service Inc · Rochelle, ILBuilt 1974 · S/N 1386N59564Sale Reported · Topeka, KSSale reportedBuilt 1974 · S/N 1389N59579American Ag Aviation Inc · Five Points, CABuilt 1968 · S/N 1480N595AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45244N595AFBlair Helicopter Service Inc · Lemoore, CABuilt 1971 · S/N 71-20749N59600Henke Jeff A · Perry, OKS/N 1420N598GYAerial Defense Holdings LLC · Kalispell, MTBuilt 1970 · S/N 70-15598N59CPAtomic Eft LLC · Scottsdale, AZBuilt 2008 · S/N 0591EN5BGLinscott Jeffrey Rodman · Boring, ORBuilt 1988 · S/N S799N5JUMoor Halley R Jr · Hankamer, TXBuilt 1981 · S/N 3427N5NUHawkeye Helicopter LLC · Lyndon, KSBuilt 1971 · S/N 722N5TCCity Of Atlanta · Atlanta, GABuilt 1977 · S/N 2282N5TVHelicopters Inc · Linden, NJBuilt 1988 · S/N 4036N600SPMagenta Aviation Solutions LLC · Wilmington, DES/N 7273N6025XSarkinen Plumbing Inc · Portland, ORBuilt 1980 · S/N 6025N602WCBlair Helicopter Service Inc · Lemoore, CABuilt 1970 · S/N 70-15633N6032ESummit Helicopters Inc · Salem, VABuilt 1996 · S/N 5232N6063GPowerbox Aviation LLC · Henderson, NVBuilt 1981 · S/N 6063N606LBKato Aviation LLC · Henderson, MNBuilt 1978 · S/N 2448N6073VSpate Aviation LLC · Albuquerque, NMBuilt 1981 · S/N 6073N608RANorth Wind Aviation LLC · Chelan, WABuilt 1978 · S/N 2511N60NMObrien Helicopters Inc · Fort Myers, FLBuilt 1995 · S/N 7651N60PHTop Gun Aviation LLC · Wendell, IDBuilt 1969 · S/N 304N60PJAero Products Component Services Inc · Show Low, AZBuilt 1978 · S/N 2349N610DATimcoaviation LLC · Purvis, MSBuilt 1981 · S/N 3447N612Jjs Aviation LLC · Bellevue, IABuilt 1991 · S/N 4200N6139QRanney Steven C · Cordova, AKBuilt 1974 · S/N 1276
Back to AD 79-21-01 R1