OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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

N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995N64063Bowers Alan B · Bellevue, WABuilt 1975 · S/N 17264996N64065Lg Holdings LLC · Gretna, NES/N 17275514N64067Duvall Chris D · Tahlequah, OKBuilt 1975 · S/N 17264998N64069Whiskey Tango Aviation LLC · Keene, NDBuilt 1981 · S/N 17275515N6406BWojtacha Jacob M · Wasilla, AKBuilt 1956 · S/N 29606N6406EOwczarek Przemyslaw J · Hampton Bays, NYBuilt 1959 · S/N 46506N64074Green Norman D · Lake City, FLBuilt 1975 · S/N 17265000N64079Portneuf Holdings LLC · Chubbuck, IDBuilt 1981 · S/N 17275516N6407BMclean Diane A · Weirsdale, FLBuilt 1956 · S/N 29607N6407DWalo Enterprises LLC · Aurora, COBuilt 1979 · S/N 17272790N6407EN6407e LLC · Hanover, MDBuilt 1959 · S/N 46507N6407VWard Matthew A · Fort Worth, TXBuilt 1980 · S/N 172RG0669N64081Burrows Donna M Trustee · Grain Valley, MOBuilt 1975 · S/N 17265004N64082Mcdonald Douglas W Sr · Cornelia, GABuilt 1975 · S/N 17265005N64087California Airways LLC · Hayward, CABuilt 1981 · S/N 17275519N6408EMorgan Lloyd J · Memphis, MOBuilt 1959 · S/N 46508N6408GWebb Joe R · Union, WABuilt 1979 · S/N 17273594N64091Fahnestock John L · Melbourne, FLS/N 17266497N64092Falcon William D · Elkhorn, WIS/N 17265012N64095Righthand 2004 LLC · Charlotte, NCBuilt 1975 · S/N 17265015N64096Bissey Roy H II Trustee · Big Horn, WYBuilt 1975 · S/N 17265016N6409DMontgomery Aviation LLC · San Diego, CABuilt 1979 · S/N 17272791WPN6409EChehalis Skies Aircraft LLC · Chehalis, WABuilt 1959 · S/N 46509N6409KBredvold Daniel M · Mendota Heights, MNS/N 17274098N640MGAviate LLC · Green Bay, WIBuilt 1975 · S/N 17265248N640SPJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8048N64103Parra Raymond · Miami, FLS/N 17275522N64106Long Leslie Bruce Jr · New Durham, NHBuilt 1981 · S/N 17275523N64107Cmbb Enterprises LLC · Plainview, TXBuilt 1975 · S/N 17265023N64108Wiater Mark S · Crete, ILBuilt 1975 · S/N 17265024N6410EKelaita Dean M · Mokelumne Hill, CABuilt 1959 · S/N 46510N6410VEckerle Christopher K · San Bruno, CABuilt 1980 · S/N 172RG0672N64111Jasper Co Airport Authority · Rensselaer, INBuilt 1975 · S/N 17265027N64114Mccully Aviation LLC · Payson, AZBuilt 1975 · S/N 17265030N64119Augustus Aircraft LLC · Whitefish, MTBuilt 1975 · S/N 17265034N6411VSouth Air Aviation LLC · Miami, FLBuilt 1980 · S/N 172RG0673N64120Ham Derek · Independence, ORS/N 17265035N64129Atlanta Aviation Academy Inc · Lawrenceville, GAS/N 17275525N6412BFlight Expo Inc · Princeton, MNS/N 29612N6412DPort Aero Club Inc · Gold River, CABuilt 1979 · S/N 17272792N6412EJoseph Jeric A · Lincoln, MTBuilt 1959 · S/N 46512N6412FRick Aviation Inc · Newport News, VABuilt 1979 · S/N 17273220N64134Torres Felix · Dallas, TXBuilt 1975 · S/N 17265039N64135Flying Mermaid LLC · Aiea, HIBuilt 1975 · S/N 17265040N6413BMccroan William R · Blountstown, FLBuilt 1956 · S/N 29613N6413ESchad Tom J · Gainesville, TXBuilt 1959 · S/N 46513N64140C64140 LLC · Bloomington, INBuilt 1975 · S/N 17265043N64147Summit Aviation Inc · Kingston, NYBuilt 1975 · S/N 17265047N6414BFamuliner Dennis M · Carrollton, MOS/N 29614
Back to AD 90-06-03 R1