OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,359

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.

N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215N1013EFouts Chester L · Turner, MTBuilt 1977 · S/N 970-77N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216N1014EMeade Lance M · Stinson Beach, CABuilt 1977 · S/N 1203-77N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931N1014GUpchurch Kenneth A · Baxley, GABuilt 1996 · S/N 20049CN1014ZMorse Spencer W · Colorado Springs, COBuilt 1970 · S/N 108N1015CCrabtree Chris R · Mooresville, NCBuilt 2020 · S/N STD-FG-565N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N1016FFly Cadillac LLC · Tustin, MIS/N 17272932N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587N1017EButtanda Denise · Winchester, VABuilt 1977 · S/N 342-77N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319N10183Excelsior Aviation 2 LLC · Lewes, DES/N P234N1018EEichman Christopher J · Lake Oswego, ORBuilt 1977 · S/N 245-77N10198Coonfield Russell A · Fayetteville, ARS/N 603N1019FFly By Aviation LLC · Sun Valley, CABuilt 1979 · S/N 17272933N1019MBeaudoin Bernard P · Piseco, NYBuilt 1995 · S/N 20041CN1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232N101ACPyewacket Air LLC · Helena, MTS/N 361-92N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208N101AWHurley Michael P · Wasilla, AKBuilt 1999 · S/N 1445N101BCHill Sheldon S · Red Lodge, MTBuilt 2008 · S/N 511-2008N101BJBlanchfield George Trustee · Yelm, WAS/N SCHUMACHER 0001N101BTMartin John D · Billings, MTBuilt 1996 · S/N 3356N101BVMundwiler David · Hemet, CAS/N 674N101BYRegistered aircraftBuilt 2004 · S/N 9492004N101CRush David T · Durham, NCBuilt 1949 · S/N 62N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290N101DDa Plane LLC · Longmont, COBuilt 1954 · S/N 3N101DFFrench James H · College Park, MDBuilt 2000 · S/N 705RN101DKTremper John D · Newton, NJS/N 1001N101DMClunan John S · Chocorua, NHBuilt 1975 · S/N 391N101DTCristal Air Inc · Wilmington, DEBuilt 1980 · S/N 1N101EBKinneen Simon N · Nome, AKS/N 18-7809028N101ECAtkinson Justin Shane · Fairbanks, AKBuilt 1978 · S/N 24-0593N101EMMartin Edward B · Peachtree City, GABuilt 2002 · S/N 001N101F5g Air LLC · Rhome, TXBuilt 1959 · S/N 7HC-11N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417N101GEEastwood Justin · Stow, OHBuilt 2000 · S/N 2389N101GLAssociated Aircraft LLC · San Diego, CAS/N 0714N101GNGreat Northern Aircraft Inc · Griffith, INBuilt 1976 · S/N 28-7615214N101HRZia Aerospace LLC · Albuquerque, NMS/N COBB 001N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920N101JDresden Leasing LLC · Sheridan, WYBuilt 1965 · S/N 28-20898N101JCCoonbottom Aviation LLC · Wilmington, DEBuilt 2003 · S/N 23818N101JKKaras Dean · Lansing, KSS/N 28R-7335243
Back to AD 90-04-06 R1