OpenAirDocs.org
AD 90-04-06 R1

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
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.

N1149AFodor Scott M · Barryton, MIBuilt 1951 · S/N 18-743N114ABHartnell Bernard L Trustee · Grand Junction, COBuilt 2018 · S/N 140102N114AZWebb Brent E · Safford, AZBuilt 2019 · S/N 140304N114BBServtek LLC · Waterloo, WIBuilt 1977 · S/N 24-0118N114BCBoatman John H Jr · Smyrna, TNS/N 376N114BGJohnson Mark A · Thousand Oaks, CABuilt 1987 · S/N 216N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080N114CMCunningham Terence R · Santa Barbara, CABuilt 1977 · S/N 18-7709146N114DCHaley Jack Michael Trustee · Keller, TXBuilt 1990 · S/N 057N114DJJohnson Danny A · Joplin, MOBuilt 1994 · S/N 455N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N114DSNewberg Curtis · Willmar, MNBuilt 2007 · S/N 80886N114ECBulldog132llc · Boulder, COBuilt 1971 · S/N BH100/132N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720N114GJefferson Devin S · Sandia, TXS/N TK-1N114JCRossi Michael W · Boca Raton, FLBuilt 1984 · S/N 1092N114JKKrueger Grant M · Fort Bragg, CAS/N 2006-1N114JMC29 Taildragger LLC · Middleton, WIBuilt 2006 · S/N 481-2006N114KKMckissick Vern L III · Harrisburg, PABuilt 1977 · S/N 13163N114MAAxel Aviation Inc · Roswell, GABuilt 2000 · S/N 305N114NXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995289N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094N114RTTerhaar Ron · Albany, ORBuilt 2001 · S/N 60046N114SCChristiansen Robert Scott · Rapid City, SDBuilt 1979 · S/N 7-2-50N114SHHatton Richard L · Lakeview, ARBuilt 1993 · S/N 39-GF 5566N114TAviation Training Solutions LLC · Hilo, HIBuilt 1952 · S/N 18-2228N114TJKnochenmus Matthew L · Corcoran, MNBuilt 1996 · S/N 382-96N114TVSafi Masoud · Mckinney, TXS/N 1333N114VGN22vg LLC · Milford, NJS/N 2351N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695N114VVAugust Aero LLC · Kalispell, MTBuilt 1986 · S/N 114N114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744N1150JAircruz LLC · Maumelle, ARBuilt 1974 · S/N 150N1150PGiermek Peter T · Olean, NYBuilt 1955 · S/N 23-163N1150SWoodraska Kenneth A · Oelwein, IABuilt 1997 · S/N 4103N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394N1151ALangdon William W · Lebanon, ORBuilt 1951 · S/N 18-745N1151JRescue Evangelical Church · Fitchburg, MABuilt 1974 · S/N 151N1151LClassic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1233N1152CTaylor Jimmie D · Hedley, TXBuilt 1953 · S/N 18-2210N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452N1153AHolder Robert W · Pittsfield, PABuilt 1968 · S/N 18-747N1153LSeelye Donald C · Charlevoix, MIBuilt 1965 · S/N 315N1154CStewart Daniel C III · Chugiak, AKBuilt 1953 · S/N 18-2212N1154YDunn Tom M · Lake Placid, FLBuilt 1996 · S/N 887-320-684SFBN11559Lackey Stephen T · Wadsworth, TXBuilt 1997 · S/N LHM-010296-MDH
Back to AD 90-04-06 R1