OpenAirDocs.org
AD 83-15-07 R1

Registered aircraft · 132

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:83-15-07-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-15-07-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.

N84645In The Grey Aviation LLC · Seadrift, TXS/N 0380N8499BJackson Paul Douglas · Chesapeake, VABuilt 1980 · S/N 0058N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N85DHRobinson Helicopter Co · Torrance, CAS/N 4967N9015VAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 0011N9017ZHelicopteracademy.Com LLC · Rebhoboth Beach, DES/N 0017N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120N9059QStevens Donald F · Canton, GABuilt 1981 · S/N 0143N90669Cape Copters LLC · Scott City, MOBuilt 1981 · S/N 0119N9068SBuehler Andrew · Eatonville, WABuilt 1981 · S/N 0172N9069FWoodman Dwight C · Hudson, FLBuilt 1981 · S/N 0177N90743Byrne Matthew A · West Allis, WIBuilt 1981 · S/N 0246N90744Central Virginia Aviation Inc · North Dinwiddie, VAS/N 0250N90748Robinson Helicopter Co · Torrance, CABuilt 1982 · S/N 0256N9074DHill Russell DBA · Seminole, TXBuilt 1981 · S/N 0234N90759Kemp Acquisitions LLC · Lone Jack, MOBuilt 1982 · S/N 0254N9075ZLimbacher Richard A · Stone Creek, OHBuilt 1982 · S/N 0253N90783Rudd Wayne G · Basalt, COBuilt 1982 · S/N 0290N9078FReynolds Darryl G · Wills Point, TXBuilt 1982 · S/N 0282N9079NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1982 · S/N 0295N907LEAll Her Fault LLC · Fairbanks, AKBuilt 2004 · S/N 3623N92236Garfoot William K · Verona, WIBuilt 1982 · S/N 0233N930AMDel Mar College · Corpus Christi, TXBuilt 1984 · S/N 0351N969ERWooten Dudley R · Dimmitt, TXS/N 4719N980CGViper Leasing LLC · Sarasota, FLBuilt 2007 · S/N 4198N981SLRotor Technologies Inc · Nashua, NHBuilt 1998 · S/N 2871N985SHAlamo Flight Academy LLC · San Antonio, TXS/N 4085N991KCSalt Lake Community College · Salt Lake City, UTBuilt 1999 · S/N 2898N992KCAg Ranch Services LLC · Lewistown, MTBuilt 1999 · S/N 2924
Back to AD 83-15-07 R1