OpenAirDocs.org
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.

N3805NHopkins Michael P · Granbury, TXBuilt 1968 · S/N 680124N3805PSpinner Family Lp · White City, ORBuilt 1955 · S/N 22-3494N3805TEyth Isaac S · Fe Warren Afb, WYBuilt 1969 · S/N 28R-30119N38062Marquez Naoko Quena · Henderson, NVBuilt 1980 · S/N WA-204N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774N3806MAbbott Cedric M · Buckfield, MEBuilt 1947 · S/N 12-2563N3806TFacklair LLC · Granville, OHBuilt 1967 · S/N 28R-30120N3806ZNamtvedt Erik · Wasilla, AKS/N 18-7539N38079Wingnut Inc · Wilmington, DEBuilt 1941 · S/N 6775N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775N3807JJohnson Gunnar W · Wasilla, AKBuilt 2012 · S/N 00100N3807KFaucette Micro Systems Inc · Fallon, NVS/N WA-200N3807MRenner Robert C · Erie, PABuilt 1947 · S/N 12-2729N3807PLuebber Jan D · Malaga, WAS/N 22-3496N38086Autumn Crocus LLC · Cincinnati, OHS/N WA-210N3808ASturges George S Jr · Bakersfield, CAS/N 22-1868N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776N3808MWings Of Clearfield Inc · Centre Hall, PABuilt 1978 · S/N 28-7816377N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834N3809MWood Robert A V · Anchorage, AKBuilt 1947 · S/N 12-2731N3809TMiller Jo Ann · Atlanta, GABuilt 1967 · S/N 28R-30124N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211N3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeBuilt 1980 · S/N WA-212N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213N380BPenn-Tex Helicopters Inc · New Iberia, LAS/N MHTC-7N380BPMoe Michael J · Detroit Lakes, MNBuilt 1996 · S/N 1N380BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010084N380CCHolmstrom Eric C · Las Vegas, NVBuilt 2001 · S/N 9934CCN380GPaxton Ronald R · Colorado Springs, COBuilt 1972 · S/N 380N380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011N380KPPeterson Timothy J · Watertown, SDBuilt 1947 · S/N 11-1586N380MCVeturis David L · Lake Forest, CAS/N 128-1054N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559N380MFRegistered aircraftBuilt 2003 · S/N 0038N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005N380RBShea Michael P · Nashua, NHBuilt 1987 · S/N 380N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211N380WGGuhl Wolfgang · Marietta, GABuilt 2010 · S/N 91618N380XBourgeois Olivier F · North Andover, MABuilt 1975 · S/N 177RG0751N381Deal Mark A · Spartanburg, SCBuilt 1978 · S/N 3072N38109Morris John · Oconomowoc, WIBuilt 1941 · S/N 6806N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378N3810TN3810t LLC · Kalispell, MTS/N 28R-30125N38113Hhi Farms LLC · Hamilton, MIS/N 77-012N38118Mull Travis S · Vallonia, INBuilt 1941 · S/N 6813N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200N3811TDeleon Muniz Mario Antonio · Riverside, CABuilt 1967 · S/N 28R-30126N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520
Back to AD 90-04-06 R1