AD 90-04-06 R1

Registered aircraft · 68,377

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.

N5208RL & S Flyer LLC · Old Saybrook, CTBuilt 1979 · S/N 172RG0047N5208TGarrett Jerry M · Shreveport, LAS/N 28-7225353N5208ZArnold Tyler S · Montgomery, LAS/N 22-8878N52090Bradley Flying Assoc · Peoria, ILBuilt 1980 · S/N 17274409N52093Helgeson Jeffrey D · Colonia, NJFirst renewal noticeBuilt 1977 · S/N 177RG1168N5209HCook James F · Portland, ORBuilt 1949 · S/N 16-11N5209LKing Christian T · Rhinelander, WIBuilt 1967 · S/N 28-4501N5209RGuyer Kasey A · Billings, MTBuilt 1974 · S/N 17263426N5209VHawkbill Aviation LLC · Hudson, NCBuilt 1980 · S/N 172RG0470N5209WBeck Richard C · Wellington, ALBuilt 1961 · S/N 28-245N520ALentz Blaine D · Laramie, WYBuilt 1951 · S/N 2073N520AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020049N520BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842257N520BSHanshew James M · Phoenix, AZBuilt 2004 · S/N 81255N520BWWheadon William J · Napa, CABuilt 2019 · S/N 2045N520CAGruia Alin · Beaverton, ORBuilt 1977 · S/N 13187N520CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843921N520FLSiry Kristina · Mertztown, PABuilt 1971 · S/N 28-7125345N520HKirsch Kenneth L · Carneys Point, NJBuilt 1975 · S/N 325N520MSH2 Link Co · Chino, CABuilt 2006 · S/N 4496230N520PBoggs Kevin D · Washington, PABuilt 2006 · S/N 70798N520PPAdams Shannon I · Punta Gorda, FLBuilt 2011 · S/N 3140N520QLFroehlich Lawrence F · Melville, NYBuilt 2015 · S/N 72069N520RRRauch Richard B · Wilsonville, ORBuilt 2003 · S/N 81485N520TXWalker Ronald J · Cedar Park, TXBuilt 2004 · S/N 71269N520VTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 1001N520XSwaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816582N52100Delta State University · Cleveland, MSBuilt 1980 · S/N 17274412N52101Defontes Kenneth W Jr · Kingsville, MDS/N 177RG1170N52106Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1980 · S/N 17274413N5210FSloan Nathan S · Owensboro, KYBuilt 1979 · S/N 17273128N5210LDewilde Lee Ray · Huslia, AKBuilt 1967 · S/N 28-4502N5210RPrince Steven S · Westerly, RIBuilt 1974 · S/N 17263427N5210T51st Aero Squadron LLC · Hoover, ALBuilt 1972 · S/N 28R-7235195N5211Dacy Julia A · Harvard, ILBuilt 1967 · S/N M-1N52119Big E LLC · Lemoore, CAS/N 17274418N5211LDuncan Timothy Scott · Sioux Falls, SDBuilt 1967 · S/N 28-4503N5211MSinger Seth · Suffern, NYBuilt 1973 · S/N 17262585N5211WRupesh Patel · Waycross, GABuilt 1961 · S/N 28-247N5211ZFlightwerx Inc · Deland, FLS/N 24-1653N52120Compass Aviation Maintenance LLC · Shelby, NCBuilt 1977 · S/N 177RG1173N52123Titop Ltd · Wilmington, DEBuilt 1980 · S/N 17274419N5212BMarble Toby J · Reno, NVBuilt 1956 · S/N 1075N5212EFinley Bryce · Sandy, UTBuilt 1978 · S/N 17271772N5212KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274012N5212ZYetter Mark A · Georgetown, PABuilt 1961 · S/N 22-8884N52132Registered aircraftS/N 177RG1174N52139Mann Aviation Inc · Long Beach, CABuilt 1980 · S/N 17274421N5213HWelding James D · Hilliards, PABuilt 1975 · S/N 17265376N5213LSchultz Lillian I · Henderson, TXBuilt 1967 · S/N 28-4505
Back to AD 90-04-06 R1