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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4328AHubert Matthew J · Fremont Center, NYBuilt 1956 · S/N 22-3683 N4328BRepeta Wayne Robert · Bedford, NHBuilt 1983 · S/N 32R-8429003 N4328HCalabretta Charles J · Hanford, CABuilt 1978 · S/N 24-0708 N4328JWeldon Thomas · Marysville, OHBuilt 1967 · S/N 28-22703 N4328NTalker Albert · Stroudsburg, PABuilt 1983 · S/N 28-8416020 N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228 N4328TWhite Mickey S · Hyrum, UTBuilt 1970 · S/N 28-26927 N4328XWhitehair Donald N · Stevensville, MTBuilt 1946 · S/N 12144 N4328ZWilmarth Rebecca C · Red Devil, AKBuilt 1968 · S/N 18-8646 N43291Etheredge Mark · Pell City, ALBuilt 1974 · S/N 28-7415448 N4329FStrathman Aerial Spraying LLC · Axtell, KSBuilt 1980 · S/N 36-8060009 N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021 N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022 N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229 N4329XS&S Aircraft Inc · Bennington, VTBuilt 1975 · S/N 28R-7635011 N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619 N4329ZWalters Leif C · Wasilla, AKBuilt 1968 · S/N 18-8644 N432AEArnold Neil · Caro, MIBuilt 1968 · S/N 690019 N432BPLaporte Enterprises LLC · Midland, TXBuilt 2005 · S/N T18208475 N432CMFuller Carl C · Fairplay, MDS/N 25105 N432CWValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 31-7512012 N432DGBiddle Dave S · Cave Creek, AZBuilt 2001 · S/N 60210 N432DPZarick Edward T III · Fort Myers, FLBuilt 1978 · S/N 32R-7887092 N432DRJazz Air LLC · Melbourne, FLBuilt 1997 · S/N 3246084 N432EAVanderloop Equipment Inc · Brillion, WIBuilt 2005 · S/N T18208432 N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652 N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547 N432KCKjomo Aviation LLC · Ocean Springs, MSBuilt 2004 · S/N 3246225 N432MBJenks Jesse Basil · Cambria, CABuilt 2011 · S/N 001 N432MEEdwards Michael S · Sacramento, CAS/N 18-7609131 N432NCHerbert Jason Brian · Saginaw, MIBuilt 1978 · S/N 32R-7885090 N432PWSimple Aviation LLC · Suwanee, GABuilt 2014 · S/N 92051 N432RCRegistration Pending · Kalispell, MTRegistration pendingBuilt 2001 · S/N RC1001 N432RVShort Thaddeaus Allen · Conroe, TXBuilt 2006 · S/N 60269 N432TTBeam John A III · Old Hickory, TNBuilt 2000 · S/N 21089 N433Precision Air Inc · Manning, SCBuilt 1979 · S/N AA5B1189 N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026 N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230 N4330RBellinger Joshua · Monterey, CABuilt 1983 · S/N 28-8411005 N4330TBc 180 LLC · Chouteau, OKBuilt 1971 · S/N 28-7205142 N4330ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1968 · S/N 18-8650 N43311Myers James · Coolidge, AZBuilt 1974 · S/N 28-7425355 N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029 N43316Double M Aviation LLC · Lakeland, FLBuilt 1974 · S/N 28-7415468 N4331BParker Charles B · Fort Myers, FLBuilt 1983 · S/N 32-8406003 N4331CLance Air Inc · Taylorsville, KYBuilt 1983 · S/N 32R-8413004 N4331DAlvarado John · Brownsville, TXBuilt 1983 · S/N 28-8411004 N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028 N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029 N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231

Back to AD 87-10-06 R1