OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,483

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:84-10-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:84-10-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.

N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108N27FCWalburn John M · Mansfield, OHBuilt 1962 · S/N 18254410N27GHNelson Aviation LLC · Chesterfield, MOBuilt 2017 · S/N 18283019N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105N27TGHarrison Mark A · Corpus Christi, TXS/N R18201065N27VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 18268451N27WDDrummond Jonathan B · Curtice, OHBuilt 1963 · S/N 205-0376N2800FMeyer Scott R · Palm Harbor, FLBuilt 1966 · S/N 18256900N2800YCherokee 92t LLC · Polk, OHBuilt 1962 · S/N 18253800N2801KGerrity James L · Homer, AKBuilt 1979 · S/N 18053072N2802AHamilton Elson · Fort Bragg, CABuilt 1953 · S/N 30002N2802FC-All Mfg Inc · Atoka, OKBuilt 1966 · S/N 18256902N2802JCentral States Aerial LLC · Polo, ILBuilt 1979 · S/N T18803515TN2802KBloom Timothy Scott · Chugiak, AKBuilt 1979 · S/N 18053073N2802QPrecision Management LLC · Bossier City, LABuilt 1962 · S/N 18254034N2803KMunro Gregg · Kenmore, WABuilt 1979 · S/N 18053074N2803YDakota Aircare Inc · Wagner, SDS/N 18253803N2804CCampbell Mark · Burleson, TXBuilt 1978 · S/N R18200229N2804FChristensen David W · Lyman, UTBuilt 1966 · S/N 18256904N2804RBarnhill Gregory L · Leawood, KSBuilt 1967 · S/N 18258404N2804YLyons Brian E · Cortez, COBuilt 1962 · S/N 18253804N2805AWeibert Jarvis Tye · Kalispell, MTBuilt 1953 · S/N 30005N2805KNorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18053076N2806AJackson Todd M · East Wenatchee, WABuilt 1953 · S/N 30006N2806YPautler Justin H · Alden, NYBuilt 1962 · S/N 18253806N2807AWoodley Aerial Leasing LLC · Walnut, ILBuilt 1953 · S/N 30007N2807KLeseberg Mark E · Minden, NVBuilt 1979 · S/N 18053078N2808KCam Corporation · Fairbanks, AKBuilt 1979 · S/N 18053079N2808RInman Matthew · Gallatin, TNBuilt 1967 · S/N 18258408N2809FOverbaugh Gary R · Highland, UTBuilt 1966 · S/N 18256909N2809RTerwillegar Charles E · Renton, WABuilt 1967 · S/N 18258409N280CSYolo Farms LLC · Raleigh, MSBuilt 1999 · S/N 18280511N280HB280hb LLC · Brighton, MIBuilt 1966 · S/N 18256901N280JPDraaisma Jacob Jr · Middleville, MIS/N 50825N280SWKatie Investments Inc · Little Rock, ARBuilt 1978 · S/N 20604561N2810FDancing On Blue Lc · Las Vegas, NVBuilt 1966 · S/N 18256910N2810KWair Inc · Mount Vernon, WABuilt 1979 · S/N 18053081N2810RSeller Mark E · Hutchinson, MNBuilt 1967 · S/N 18258410N2811FLien Craig C · Plains, MTBuilt 1966 · S/N 18256911N2811KHayward Houston C · Lansdale, PABuilt 1979 · S/N 18053082N2811YCotti Kevin P · Plymouth, MABuilt 1961 · S/N 18253811N2812KSylvester John A · Hereford, AZBuilt 1979 · S/N 18053083
Back to AD 84-10-01 R1