Registered aircraft · 68,369

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N2483KVan De Wall Allan G · Oro Valley, AZBuilt 1979 · S/N 38-79A0660 N2483MLanners Thomas P · Chickaloon, AKBuilt 1947 · S/N 12-1684 N2484KGladden Jeffrey S · Rustburg, VABuilt 1979 · S/N 38-79A0661 N2484MRegistered aircraftAssigned, pending cancellationS/N 12-1686 N2484NChihuahua Airport Partners Lp · Plano, TXS/N 38-79A0865 N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414 N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415 N24859Moore Jeffrey B · Pendleton, INBuilt 2000 · S/N 248 N2485ALees Jerry D · Fairbanks, AKBuilt 1952 · S/N 18-1954 N2485LHamilton Terry W · Bulverde, TXBuilt 1979 · S/N 38-79A0719 N2485MMason Michael S · Sequim, WABuilt 1947 · S/N 12-1559 N2485RGriffith Kyle R · Talihina, OKBuilt 1969 · S/N 28-5633 N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069 N24869Dejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1931 · S/N 3510 N2486LManley Steven T · Dallas, TXBuilt 1979 · S/N 38-79A0720 N2486MBartel Christopher H DBA · Williamsburg, PABuilt 1948 · S/N 12-1685 N2486PWoods Jerry Lee II · Murchison, TXBuilt 1955 · S/N 22-2860 N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427 N2487AHoffman Gary D · Spencer, NEBuilt 1952 · S/N 18-1956 N2487HEllis Wendell K · Chugiak, AKBuilt 1979 · S/N 18-7909195 N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431 N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432 N2488APetrik Kale O · Sidney, MTBuilt 1952 · S/N 18-1969 N2488CEddins Mark D · Pensacola, FLFirst renewal noticeBuilt 1978 · S/N 38-79A0202 N2488FHatter Dan D · Dumas, TXBuilt 1979 · S/N 38-79A0474 N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289 N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282 N2489Arcara Sebastiano V · New Smyrna Beach, FLS/N 020 N24895Lokker Dirk E · Oakdale, CABuilt 1977 · S/N 15280438 N2489ALong Patrick B · Buffalo, WYS/N 18-1957 N2489BKlauschie David A · Papillion, NEBuilt 1978 · S/N 38-79A0085 N2489KMartin Brennan Stern Jr · Bristol, TNBuilt 1979 · S/N 38-79A0662 N2489MBarker Gerald E · Weymouth, MAS/N 12-1695 N2489NDeschamps Joseph L · Barre, MABuilt 1979 · S/N 38-79A0871 N248BFotheringham Jack · Palmer, AKS/N 28-7505135 N248BFBohmer Alexander J · Moorhead, MNBuilt 2008 · S/N 5337 N248CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881003 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572 N248MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881711 N248MMFouts Michael W · Canton, GAFirst renewal noticeBuilt 1995 · S/N 1248 N248PVVasquez Pablo Javier Jr · El Dorado Hills, CABuilt 1991 · S/N 243221 N248SWHicks James P · Franklin, OHBuilt 2013 · S/N 688 N248TGiannonatti Lance A · Ludlow, SDBuilt 1953 · S/N 18-2362 N248TTLohrman Lonny A · Wichita, KSBuilt 2018 · S/N 25408 N24905Cochran David · Richmond, KSBuilt 1939 · S/N 3528 N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445 N2490BExperimental Acft Assoc Inc · Oshkosh, WIBuilt 1956 · S/N 1516 N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254 N2490VPiper Aircraft Inc · Vero Beach, FLBuilt 1982 · S/N 38-82A0068

Back to AD 90-04-06 R1