OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,484

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.

N195HCalef Jere R Trustee · Mojave, CABuilt 1948 · S/N 7200N195HADodge Inc · Wilmington, DEBuilt 1965 · S/N 7438N195HJJorgensen Bryan H · Wadsworth, OHBuilt 1952 · S/N 7880N195JGores Thomas J · Franklin, WIBuilt 1954 · S/N 16123N195JAR H K Of Kansas Inc · Overland Park, KSBuilt 1950 · S/N 7504N195JBMoore Glenn C · Elkhart Lake, WIS/N 7220N195JDBoswell Kurt R · Renton, WAS/N 7603N195JFDark Ark Enterprises LLC · Bentonville, ARBuilt 1950 · S/N 7576N195JLLambert James A · Enumclaw, WABuilt 1952 · S/N 7944N195JPJacobs David E · Saint Georges, DEBuilt 1951 · S/N 7673N195JSScholl Jonathan W · Mckinney, TXBuilt 1952 · S/N 7872N195JWFroes Jonathan C · Little Elm, TXBuilt 1953 · S/N 16094N195KPlymate Jeffrey L · Sandy, ORS/N 7867N195KBHubner Leigh Andrew · Locust Grove, GABuilt 1952 · S/N 7949N195KJGilbride Richard L · Ringgold, GABuilt 1952 · S/N 7800N195KRKiser Richard K · Grottoes, VABuilt 1948 · S/N 7160N195KSKalina David A · Johnstown, PABuilt 1950 · S/N 7582N195KWHenkemeyer Joseph S · Cave Creek, AZBuilt 1948 · S/N 7242N195LBMmm Friemel Inc · Hereford, TXBuilt 1951 · S/N 7703N195LCWindsock Holdings LLC · Amarillo, TXS/N 16144N195LGInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7303N195LNGrones John G · Port Orange, FLS/N 7824N195LSRicks Aviation Adventures LLC · Grand Forks, NDBuilt 1947 · S/N 7051N195LVHughes David L · Uintah, UTS/N 7813N195LWSmiley Neil G · Clover, VABuilt 1954 · S/N 16126N195MJLutz Roald F · Sandia Park, NMBuilt 1952 · S/N 7882N195MKScholten Calvin B · Lakeland, TNBuilt 1952 · S/N 7907N195MMCasa Acquistions LLC · Winter Haven, FLS/N 16032N195MSMccombs Dale A · Midlothian, TXBuilt 1952 · S/N 7994N195NHewitt Roger L · Kent, WABuilt 1953 · S/N 16075N195PDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1948 · S/N 7218N195PCBurson Anthony W · Cape Charles, VABuilt 1954 · S/N 16140N195PDDougherty Paul D Jr · Bethel, PABuilt 1950 · S/N 7460N195PKKourtis Vintage Aviation LLC · Owasso, OKBuilt 1951 · S/N 7712N195PLPerkins Terence R · Ormond Beach, FLBuilt 1948 · S/N 7262N195PRRg Aviation Inc · Wilmington, DEBuilt 1952 · S/N 7871N195PWRieke Rhett · Bigfork, MTBuilt 1949 · S/N 7647N195QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7743N195RAJaeb Gerald E · Yankeetown, FLS/N 16099N195RCDuke Kay L · Darrouzett, TXBuilt 1953 · S/N 16102N195RERamey Robert L · Rose Hill, KSBuilt 1952 · S/N 7934N195RJJeffries Ronald G · Manson, WAS/N 7899N195RKLinnane Cory E · Schaumburg, ILS/N 7393N195RSInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 7594N195RWWhite Michael D Trustee · Willow Springs, MOFirst renewal noticeBuilt 1948 · S/N 7088N195SFreedom Leasing Ent Inc · Wilmington, DEBuilt 1952 · S/N 7924N195SBJones Caleb A · Sanger, TXBuilt 1952 · S/N 7911N195SCSmith William E · Highland, CABuilt 1949 · S/N 7402N195SELewis Leigh Wade · Rockledge, FLS/N 7857N195SMBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7806
Back to AD 84-10-01 R1