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.

N9147THoiles Richard C · Shortsville, NYBuilt 2006 · S/N 632EN9147VN206ht LLC · Pulaski, IABuilt 1969 · S/N 690037N9148GCheutin Didier V · Orlando, FLBuilt 1995 · S/N 24-3362N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787N9149JJones Lynn · Birmingham, ALS/N 28-3204N9149QCovington James A · Huntsville, ALBuilt 1996 · S/N 24-3377N9149SBurnard Russell J · Seward, AKBuilt 2001 · S/N 456RN914ADDepinet Andrew P · Galion, OHBuilt 2026 · S/N 001N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914DSaker Air LLC · Charlotte, NCBuilt 2000 · S/N 1104N914ETrettin Anthony K · Mason City, IABuilt 2005 · S/N 70599N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124N914HMeadows Mark A · Mooresville, INBuilt 1999 · S/N 21325N914HMMiesler Hans U · Penrose, COBuilt 1971 · S/N 1N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914JWWright John T · Jacksonville, FLBuilt 1975 · S/N 419N914PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843303N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914SCole Thomas Ed · White Settlement, TXS/N 106N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347N914VNewhouse Flying Service Inc · Fredericksburg, TXBuilt 1931 · S/N 4004N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N9150VUrness John · Oakland, CABuilt 1969 · S/N 690038N91518Hatfield Timothy E · Parowan, UTBuilt 1996 · S/N 3121N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N9151VNeret Michael G · Sugarland, TXBuilt 1969 · S/N 690031N9151YRegistration Pending · South Jordan, UTRegistration pendingBuilt 1995 · S/N 24-3366N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400N9153VRegistered aircraftBuilt 1969 · S/N 690027N91544Piper Aircraft Inc · Vero Beach, FLBuilt 1981 · S/N 38-82A0050N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9155VHickox Joseph C · Rollins, MTBuilt 1969 · S/N 690032N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401N9156VLegnaioli Richard · Cambridge, MDS/N 690013
Back to AD 90-04-06 R1