Registered aircraft · 54,019

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.

N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N1407SCaesar Wings LLC · Ubly, MIBuilt 1976 · S/N 18264967 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1408DParks James M · Potsdam, NYBuilt 1951 · S/N 19991 N1408SFrickel Well Service LLC · Atkinson, NEBuilt 1976 · S/N 18264968 N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108 N1409DArcher William Todd · North Pole, AKBuilt 1951 · S/N 19992 N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709 N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539 N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478 N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201 N1410DMahaffey James P · Grand Prairie, TXBuilt 1951 · S/N 19993 N1410GSierra-Mike LLC · Springdale, ARS/N 15073205 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186 N1412DKing Matthew W · Wilmington, NCBuilt 1951 · S/N 19995 N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712 N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713 N1413SAgillaire Inc · Colleyville, TXS/N 18264972 N1413VMercury International LLC · Cheyenne, WYS/N R1722187 N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113 N1414CSorby Steven R · Lyman, WABuilt 1966 · S/N 337-0419 N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909 N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714 N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559 N1415DMurphy James S · Skaneateles, NYBuilt 1951 · S/N 20131 N1415MJ T Air LLC · Cleveland, ALBuilt 1975 · S/N 18264321 N1415USale Reported · Miami, FLSale reportedBuilt 1976 · S/N 17267083 N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989 N1416MTerra Firma Aviation LLC · Bowman, CABuilt 1975 · S/N 18264322 N1416UEddy Elizabeth H · Tunbridge, VTBuilt 1976 · S/N 17267084 N1416VRegistered aircraftBuilt 1976 · S/N R1722188 N1416YOrefice Anthony C · Clio, MIBuilt 1961 · S/N 17249116 N1417MRegistered aircraftBuilt 1975 · S/N 18264323 N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717 N1417SCooper Patrick R · Houston, TXBuilt 1976 · S/N 18264974 N1417UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267085 N1417VSkyhawk Aviation LLC · Rutherfordton, NCS/N 17263562 N1418DScheer R Michael · Wilmington, NYBuilt 1951 · S/N 20001

Back to AD 87-20-03 R2