OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-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:87-10-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.

N44426Skyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842396N44429Bettencourt David A · Dayville, CTBuilt 1974 · S/N 28-7415638N4442AVella La Cava Air LLC · Albuquerque, NMBuilt 1956 · S/N 22-3772N4442XHayes Kevin R · Richmond Hill, GABuilt 1975 · S/N 28-7625034N4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeBuilt 1969 · S/N 18-8786N44430Red Eye Aviation LLC · Minocqua, WIBuilt 1974 · S/N 28-7405242N4443AVollman Merlin · Pearland, TXBuilt 1956 · S/N 22-3773N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397N4443TKristofzski John · West Richland, WABuilt 1971 · S/N 28-7105228N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044N4443ZMeekin Michael J · Palmer, AKBuilt 1969 · S/N 18-8788N44442Cummins Stephen Michael · Fenton, MOBuilt 1974 · S/N 28-7405244N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001N4444AWesolowski Chris E · Anchorage, AKBuilt 1956 · S/N 22-3774N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250N4444JMoore James Jeffrey · Midlothian, TXBuilt 2004 · S/N 3788N4444MTurbine Conversions Ltd · Nunica, MIBuilt 1997 · S/N 1APP01-01N44450Brown Roy A · Morongo Valley, CABuilt 1974 · S/N 28-7425412N44452Cdr Aviation LLC · Kalispell, MTS/N 28-7425413N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309N4445JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842398N4445KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842399N4445PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842400N4445SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842401N4445VSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842402N4445XRegistration Pending · Midlothian, TXRegistration pendingBuilt 1975 · S/N 32R-7680017N4445YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842403N4446JScherr Steven · Mandan, NDBuilt 1967 · S/N 28-22850N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188N4446ZGrant Kimberly A · Priest River, IDBuilt 1969 · S/N 18-8792N44478Richard J Farmer II · Fremont, OHBuilt 1974 · S/N 28-7405247N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601N44485Registration Pending · Middletown, OHRegistration pendingS/N 28-7415646N44488Daris James · Fitzwilliam, NHBuilt 1974 · S/N 28-7415647N4448HNorthwest Iowa Flyers LLC · Everly, IABuilt 1978 · S/N 24-0736N4448THoughton John L · Lamar, MOBuilt 1971 · S/N 28-7105227N4448ZGrow Michael J · Palmer, AKBuilt 1969 · S/N 18-8795N44494N44494 LLC · Peachtree City, GABuilt 1974 · S/N 32-7440156N44497English William E · Mason City, IABuilt 1974 · S/N 28-7425417N4449JSinatra Anthony J · Glendale, AZBuilt 1967 · S/N 28-22854N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602N4449ZStenga James E · Soldotna, AKBuilt 1969 · S/N 18-8796N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99N444BWAmigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11254N444CACentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1458-162N444CBCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1119-69N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N444CSStover Charles S · Ft Lupton, COBuilt 2001 · S/N 3994
Back to AD 87-10-06 R1