Skip to content

Registered aircraft · 54,020

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.

N1312SMid Valley Aviation LLC · Groveland, CAS/N 18264877 N1312USimplifly LLC · Mesa, AZBuilt 1976 · S/N 17267001 N1312YPierce Larry Jay · Brigham City, UTBuilt 1961 · S/N 17249012 N1313DPlowman Benjamin · Raleigh, NCBuilt 1951 · S/N 19889 N1313YSullivan Shawn M · The Dalles, ORBuilt 1962 · S/N 17249013 N13140Trailwinds Flying Club · Savannah, MOBuilt 1973 · S/N 17262523 N13143Riffel Victor · Benton, KSBuilt 1973 · S/N 17262526 N13144Barnstormers Club LLC · Cape Coral, FLBuilt 1973 · S/N 17262527 N13147Terra Piniun LLC · Chickaloon, AKBuilt 1973 · S/N 17262529 N13149Dughman Tim A · Willow, AKBuilt 1952 · S/N 19356 N1314DBartels Lance R · Freetown, INBuilt 1951 · S/N 19890 N1314FLee James Christopher · Concord, GABuilt 1966 · S/N 17254809 N1314SAviation Specialty Services LLC · Beaufort, NCS/N 33701902 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N13152Quirrion Linton A · Jay, MEBuilt 1973 · S/N 17262531 N13154Howell James W · Boise, IDBuilt 1973 · S/N 17262533 N13156Mph Aviation LLC · Eastanollee, GABuilt 1973 · S/N 17262535 N13157Red River Flyers Inc · Wahpeton, NDBuilt 1973 · S/N 17262536 N1315ETada Aero LLC · Worthington, OHBuilt 1978 · S/N 17270951 N1315FApsey Bradley D · Deckerville, MIBuilt 1966 · S/N 17254810 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1315QWhite Beth A · Keene, NHBuilt 1971 · S/N 15072615 N1315UMcgonagill Billy D · Mount Pleasant, TXBuilt 1976 · S/N 17267004 N13160Dey James M · Waterford, MIBuilt 1973 · S/N 17262538 N13164Jameson Kelly J · Chappell Hill, TXBuilt 1973 · S/N 17262542 N131691521 LLC · Antigo, WIBuilt 1973 · S/N 17262546 N13171Tagle Robert J · San Antonio, TXBuilt 1973 · S/N 17262548 N13178Tappan Jay M · St Helens, ORBuilt 1973 · S/N 17262549 N1317DBaer Monte Wayne · Ronan, MTS/N 19893 N1317EAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270952 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1317ULondondeery Flying Club Inc · Litchfield, NHBuilt 1976 · S/N 17267006 N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402 N13182Spillman Aviation LLC · Colorado Springs, COBuilt 1973 · S/N 17262552 N13185Good Flight LLC · Colchester, CTBuilt 1973 · S/N 17262554 N13187Fly Aviation Corp · Wilmington, DES/N 17262556 N1318DBott Christopher L · Pilot Point, TXFirst renewal noticeBuilt 1951 · S/N 19894 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N13190Donham Rita M · Cora, WYBuilt 1973 · S/N 17262559 N13196Frederick Christopher N · North Mankato, MNBuilt 1973 · S/N 17262563 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N1319QOutman Christopher · Lowell, MIBuilt 1971 · S/N 15072619 N1319UMarsh John E · Washington, DCS/N 17267008 N1319YWinston William F · Lake Stevens, WABuilt 1961 · S/N 17249019 N131CFBurke Christopher L · Gordon, GABuilt 1978 · S/N 15282248 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N131FROptic Air LLC · Sioux Center, IAS/N 17276252 N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668

Back to AD 87-20-03 R2