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.

N5738UFlorida Time Building LLC · Port Saint Lucie, FLS/N 28-26554N5738WCherokee 38whiskey LLC · Charlotte, NCBuilt 1963 · S/N 28-1434N57390Beyer Mark E · Towanda, KSBuilt 1973 · S/N 83-73N57394Mccombs Evan · Peyton, COBuilt 1973 · S/N 84-73N57395Zangs William J · Poplar Grove, ILBuilt 1973 · S/N 488-73N57399Aerobatic 8kcab Holdings LLC · Murchison, TXS/N 85-73N5739DSmith James A · Lyle, WABuilt 1956 · S/N 22-4439N5739HRegistered aircraftBuilt 1949 · S/N 16-351N5739LMcgll Phil · Huntsville, ALBuilt 1969 · S/N AA1-0139N5739QMorell Timothy S · Lino Lakes, MNBuilt 1965 · S/N 3108N5739WFeralova Erika H · Gresham, ORBuilt 1963 · S/N 28-1425N573ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496198N573CBMussell Lincoln D · Longview, TXBuilt 1993 · S/N 573N573ELStellaire Alliance LLC · Fort Worth, TXBuilt 1999 · S/N 2038N573JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020264N573MBWigley Barry L · Langston, ALBuilt 2024 · S/N 26009N573MWWhelan Company LLC · Hoover, ALBuilt 2005 · S/N 90815N573SMason Scott C · Lebanon, ORBuilt 1976 · S/N 913N573TMFarley Douglas C · Edmond, OKBuilt 1996 · S/N 001N57401Adams Kenneth · Marana, AZBuilt 1973 · S/N 376-73N57404Cp Aviation Inc · Santa Paula, CABuilt 1973 · S/N 940-73N57405Shoaf Douglas G · Lake Oswego, ORS/N 371-73N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N5740HPritchett Michael L · Benton, ARS/N 16-352N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072N5740UBraden Daniel · Port Charlotte, FLBuilt 1969 · S/N 28-26556N5740WAdams Clay · Anacortes, WABuilt 1963 · S/N 28-1415N5740ZLashley Chad P · Wentzville, MOBuilt 1963 · S/N 22-9579N57410Eddy William Crawford III · Sugar Hill, GABuilt 1973 · S/N 941-73N57411Gregory Larry C Trustee · Farmington, MOBuilt 1973 · S/N 372-73N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N57413Miller Sybille A · Ashburn, VABuilt 1984 · S/N 24-1450N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741LWienclaw David E · Boise, IDBuilt 1969 · S/N AA1-0141N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N57420Florida Man Aviation LLC · Saint Petersburg, FLBuilt 1973 · S/N 942-73N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57422Heefner Frederick C · Greencastle, PABuilt 1998 · S/N 23077N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5742LGjorvad Steven A · Punta Gorda, FLS/N AA1-0142N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451N57430Swanson Michael D · Council Bluffs, IABuilt 1973 · S/N 944-73N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73
Back to AD 90-04-06 R1