Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N65025Killian Larry D · Hampton, ARS/N R172-0123 N6502SPetrosyan Joseph · Rancho Cordova, CABuilt 1967 · S/N 15067302 N65032Vavrek Holly Kay · Palm City, FLBuilt 1982 · S/N 17275672 N6503ABrown Paul N · Eustace, TXBuilt 1956 · S/N 32400 N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834 N6503EDos Disparos LLC · Shallowater, TXBuilt 1984 · S/N 18268371 N6503FStockton Ketron J · Bulls Gap, TNBuilt 1973 · S/N A1500446 N6503HBrafford John Lee · Kings Mountain, NCBuilt 1979 · S/N 15284172 N6503MCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284759 N6503SElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1967 · S/N 15067303 N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736 N65040Mc Creery Aviation Co Inc · Mcallen, TXS/N 17275673 N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674 N6504EDietrich Robert R · Elizabeth, COBuilt 1980 · S/N 18504051 N6504GHoward David D · Winner, SDBuilt 1970 · S/N 15072004 N6504MSobien Andrew J III · Mountain Home, IDBuilt 1975 · S/N 18263734 N6504SNurmi Forrest Cal · Burlington, WABuilt 1980 · S/N R18201687 N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737 N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677 N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678 N6505AKenmonth Craig M · Fairbanks, AKBuilt 1956 · S/N 32402 N6505EHeman Darrick L · Blue Springs, MOBuilt 1959 · S/N 56005 N6505FCoffman Curtis M · Lakeside, ORBuilt 1966 · S/N 15063105 N6505GStern Scot G · Escondido, CABuilt 1970 · S/N 15072005 N6505MUrrea Hugo Edmundo Rincon · Katy, TXBuilt 1980 · S/N 15284760 N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075 N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681 N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835 N6506EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56006 N6506FMdowell Pilot Service LLC · South Hutchinson, KSS/N 15063106 N6506GWestern Skyways Inc · Montrose, COS/N 21064406 N6506MBeechhurst Corp · Wilmington, DEBuilt 1975 · S/N 18263735 N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633 N6506XBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57506 N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301 N6507XBailey Scott D · Ione, CABuilt 1960 · S/N 57507 N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469 N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205 N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844 N6509GMehling Robert C · Hardin, MTS/N 18801202 N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470 N6509LSnohomish Flying Service Inc · Snohomish, WABuilt 1980 · S/N 15284425 N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686 N6510EScherer Luis R · Kent, OHBuilt 1959 · S/N 56010 N6510FPrice Gregory L · Kyle, TXBuilt 1966 · S/N 15063110 N6510XSteinbroner Daniel J · Lawton, OKBuilt 1960 · S/N 57510 N65112Jav Air Services LLC · Anchorage, AKS/N 17275688 N6511EMckenna Francis · Granville, PABuilt 1959 · S/N 56011 N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603

Back to AD 87-20-03 R2