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.

N6540DCollon John C · Louisville, KYRegistration revokedBuilt 1963 · S/N 1N6540LSmith Thomas E · Williamstown, MABuilt 1973 · S/N AA1B-0340N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539N6541LOse Leroy B · Thief River Falls, MNBuilt 1973 · S/N AA1B-0341N6541URegistered aircraftBuilt 1962 · S/N 2324N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765N6542WBaird Philip D · Judith Gap, MTS/N 28-21268N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550N65439Pnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285287N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543UGiesey William · Philadelphia, PABuilt 1962 · S/N 2326N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622N65440G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281554N65442National Museum Of World War II Aviation · Colorado Springs, COS/N 77-272N65449Hoeft Cliff A · Pilot Rock, ORBuilt 1978 · S/N 15281557N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544LPencoe Glenn L · Jemison, ALBuilt 1974 · S/N AA1B-0344N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365N6544WBrown Rayford K · Temple, TXBuilt 1990 · S/N 436N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581N65468Burger John J · Ocala, FLBuilt 1978 · S/N 15281569N6546FMiljour Jack A · Sanborn, NYBuilt 1976 · S/N 28-7790153N6546UBadlands Flyers Inc · Watford City, NDBuilt 1962 · S/N 2329N65470Jt Aero LLC · Wilmington, DEBuilt 1978 · S/N 15281570N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990N6547SMiller Bradley J · Joliet, MTS/N 15067347N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626N65483American Aviation Inc · Brooksville, FLS/N 15281580N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992N6548LJudge Christopher E · Vacaville, CABuilt 1974 · S/N AA1B-0348N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771N65495Circle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 15281587N65498Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281588N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993N6549ZRivers Larry R · Talkeetna, AKBuilt 1962 · S/N 18-7879N654ACFlying Sparks LLC · Tomball, TXBuilt 1998 · S/N 1367-98N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335N654CRLinde Rodney C · Weatherford, TXBuilt 2003 · S/N 80734N654EZN654ez LLC · Oyster Bay, NYBuilt 2006 · S/N 1741
Back to AD 90-04-06 R1