OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N2696WButler Collin · Danvers, MABuilt 1966 · S/N 3325N26973Miller Ronald DBA · Hattiesburg, MSBuilt 1979 · S/N AA5A0852N26976Luke Jeffrey David · Teague, TXBuilt 1979 · S/N AA5A0855N26985Hahn Jeffrey S · Guttenberg, NJBuilt 1979 · S/N AA5A0861N26986Jones Steven A · Paola, KSBuilt 1979 · S/N AA5A0862N26988Kazakova Liudmila · Hereford, AZBuilt 1979 · S/N AA5A0864N2698PMajors Nathaniel Ray · Ball, LAS/N 18-4388N2698WLivesay Wallace · Friendswood, TXBuilt 1966 · S/N 1011N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318N26993Gugel Joseph C Jr · Gettysburg, PABuilt 1979 · S/N AA5A0866N26994G & G Aviation LLC · Stedman, NCBuilt 1979 · S/N AA5A0868N26997Niver Rex E · Jenks, OKBuilt 1979 · S/N AA5A0869N2699WKingman Connor Joseph · Lemoore, CAS/N 1012N269AReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 1050403N269ATSnyder Arthur P · Trevorton, PABuilt 2005 · S/N 1001N269BTorres Ramon A · Mulberry, FLFirst renewal noticeBuilt 1958 · S/N 127N269BFLehmann Micheal · Lena, ILBuilt 2003 · S/N 21421N269BJN2893e LLC · Reno, NVS/N 17270380N269BMOlsen Jared · Phoenix, AZBuilt 2002 · S/N 60130N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269CPCutler Adam Wilson · Kennebunk, MEBuilt 2000 · S/N 80269N269DACole Thomas Ed · White Settlement, TXFirst renewal noticeBuilt 1968 · S/N 269N269DBDesilva David I · Baton Rouge, LABuilt 1992 · S/N 20816N269HAN269ha LLC · Manassas, VAS/N S1406N269HHCaprock Technical Services Inc · Kempner, TXS/N 12-0041N269JLPeecher Carl J · Sequim, WAS/N 5020N269JPBrones Jon P · Blanco, TXBuilt 1977 · S/N 670611N269KGMvt Aviation LLC · Magnolia, TXBuilt 2013 · S/N CH402N269KMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020099N269MAOrange Wing Aviation Inc · Wilmington, DES/N 1361-2004N269MDCactus Air Force LLC · Carson City, NVBuilt 1963 · S/N 33-0175N269MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881367N269MPGustafson H Clayton · Woodbury, CTBuilt 1980 · S/N 32R8029007N269MRAgl LLC · Othello, WABuilt 1997 · S/N S1753N269NEOro LLC · Tilden, NES/N 17272505N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269RTTodd Jon R · Georgetown, CABuilt 2010 · S/N 72891N269RVHershey Lester E · Amelia Court House, VABuilt 2007 · S/N 90246N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061N269SFHarvey Kandace · Snohomish, WABuilt 1979 · S/N 690795N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363N269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationBuilt 1999 · S/N S1776N269TJSenninger Thomas P · Clermont, FLBuilt 2000 · S/N S1807N269TPPhoenix Leasing LLC · Menomonee Falls, WIBuilt 2000 · S/N 0110N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269VCRegistered aircraftBuilt 1992 · S/N S1609N269WFThomas Wilmer C · Fairbanks, AKBuilt 1999 · S/N 30007CN269WMRenninger Log Homes · Meeker, COBuilt 1959 · S/N 18-6874N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798N269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606
Back to AD 87-10-06 R1