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.

N7276TBraner Richard C Trustee · Oakdale, CABuilt 1959 · S/N 46876N7277ADrzewiecki Chad M · Cuyahoga Falls, OHBuilt 1952 · S/N 29377N7277TStrehler Stanford L · League City, TXBuilt 1959 · S/N 46877N72788Christiansen Aviation LLC · Wilmington, DES/N 17280988N7278TChudy Daniel B · Yucaipa, CAS/N 46878N7279AGoerger Allan E · Barney, NDBuilt 1956 · S/N 29379N727KDReich Brad Roy · Rohnert Park, CAS/N 17254281N727LCBurmaster Christopher R · Murfreesboro, TNBuilt 1966 · S/N 17254788N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938N727LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13590N727METruesdell Shannon · Stephenville, TXBuilt 1976 · S/N 17268426N727PMMiddlebrook Paul E · Penn Yan, NYBuilt 1981 · S/N 17275485N727RCKelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17263887N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791N727SPElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8664N727TLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1977 · S/N 17269372N727TSStreng Terry E · Columbus, OHBuilt 1973 · S/N 17262367N727ZGNelson Poultry Farms Inc · Manhattan, KSBuilt 1961 · S/N 17248125N7280AWarren Holland S · Princeville, ILFirst renewal noticeBuilt 1956 · S/N 29380N7281AWindsock Capital LLC · Bertram, TXBuilt 1956 · S/N 29381N7281TBreier Clifford G · Dardanelle, ARBuilt 1959 · S/N 46881N7284GFisher Global LLC · Faulkner, ARBuilt 1970 · S/N 17258984N7286ALipp James Oliver · Nesconset, NYBuilt 1956 · S/N 29386N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586N7287ADean William D · Jasper, GABuilt 1956 · S/N 29387N7287GTen Mile Ranch Inc · Vale, ORBuilt 1970 · S/N 17258987N7287TRfk Aerospace LLC · Clayton, NCBuilt 1959 · S/N 46887N72884Hawkeye Aviation LLC · Miami, FLBuilt 1974 · S/N 17264315N7288AHeard Benjamin A · Ellensburg, WABuilt 1956 · S/N 29388N7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeS/N 17260588N7288TSandusky Flight Academy LLC · Sandusky, MIBuilt 1959 · S/N 46888N7289TShepherd Gary D · Owosso, MIBuilt 1959 · S/N 46889N728EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13032N728FGRidgeline Assets LLC · Wilmington, DEBuilt 2024 · S/N 172S13275N728KGCapsed LLC · Mojave, CABuilt 1979 · S/N 17272662N728LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13593N728SPFleetshares N728sp Inc · Leesburg, VABuilt 2000 · S/N 172S8665N7290ARipp Fred G · Eagle River, AKBuilt 1956 · S/N 29390N7291AWarren Mark W · Arlington, WAS/N 29391N7291GKuntz Jeffrey A · Covington, OHBuilt 1970 · S/N 17258991N7291TThomas Charles A · Hockley, TXBuilt 1959 · S/N 46891N7292GMarquette County Flying Club · Marquette, MIBuilt 1970 · S/N 17258992N7292QDevereaux Bruce O · Pewamo, MIBuilt 1972 · S/N 17260592N7292TObloy James J · Brunswick, OHBuilt 1959 · S/N 46892N7293TMccamant Angus J · Alohu, ORBuilt 1959 · S/N 46893N7294APiston Aviation LLC · Saint Charles, MOBuilt 1956 · S/N 29394N7294TBurnett Albert Franklin · Lubbock, TXS/N 46894N7295GHessel Block Co Inc · Hessel, MIS/N 17258995N7295QKangas Lisa M · Fairbanks, AKS/N 17260595N7296AStoup Lyndal K · Cordell, OKBuilt 1956 · S/N 29396
Back to AD 90-06-03 R1