Registered aircraft · 1,083

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:83-03-02-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:83-03-02-R1') 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:83-03-02-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:83-03-02-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.

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:83-03-02-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:83-03-02-R1')
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.

N313APWav Series LLC · Batavia, ILBuilt 1981 · S/N 3471 N313JPPerell John · Miami Beach, FLBuilt 1972 · S/N 1120428S N316CFLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 2264 N316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479D N316RCHelicopter Emergency Lift Program · Pomona, NYBuilt 1974 · S/N 1268 N3188ZFulton County Police Headquarters · Atlanta, GABuilt 1985 · S/N 3860 N3192G3192 Golf Inc · Wauchula, FLBuilt 1972 · S/N 809 N3196GUSA Helicopter Inc · West Winfield, NYBuilt 1972 · S/N 775 N31ATHelicopter Leasing Inc · Coral Gables, FLBuilt 1972 · S/N 918 N31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027D N3202DPapa Mike Aviation LLC · Dousman, WIBuilt 1985 · S/N 3849 N3211NTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1984 · S/N 3808 N321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342E N322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218 N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303 N326MHMaritime Helicopters Inc · Homer, AKBuilt 1988 · S/N S-803 N327MHMaritime Helicopters Inc · Homer, AKBuilt 1989 · S/N S813 N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875 N330THHuff Jon L · Corning, NYBuilt 1992 · S/N 0002 N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564 N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735 N332JPAeronautical Airmotive Modifications Inc · Biscayne Park, FLS/N 7358 N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763 N333TABallard Aviation Inc · Newton, KSBuilt 1979 · S/N 590500D N334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303 N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330 N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107 N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337 N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253 N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703 N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637 N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516 N353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079D N355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109 N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436 N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133 N355SFHowe Aviation LLC · Surprise, AZS/N 5054 N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111 N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355 N357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171D N358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736 N360JFCt Grain Systems LLC · Lewisburg, KYS/N 0031A N364KRWright Kris H · Idaho Falls, IDBuilt 1984 · S/N E2184 N369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209D N369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167D N369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861D N369GSHellyer Aviation · Worland, WYBuilt 1973 · S/N 1230548S N369HAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 660821S N369HEN369he LLC · Wickenburg, AZBuilt 1969 · S/N 1090205E N369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763S

Back to AD 83-03-02 R1