Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N335MDHamstra Armen Nofer · Saratoga, CABuilt 1982 · S/N 32-8206036 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N33631First Class Emergency Vehicles LLC · Monroe, NCBuilt 1975 · S/N 32-7500026 N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213 N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349 N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166 N33645Conner W Larry · Los Lunas, NMBuilt 1975 · S/N 32-7540108 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N3364WOconnell Killian R · Amherst, MABuilt 1965 · S/N 32-210 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172 N33669Ellsworth Donald · Beverly Hills, FLBuilt 1975 · S/N 32-7540110 N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298 N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174 N33685Leighty Brian D · Dighton, KSS/N 28R-7535179 N3368WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1965 · S/N 32-214 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N33694Fly LLC · Natchez, MSBuilt 1975 · S/N 32-7500029 N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181 N33699Burris D Rob Trustee · Tucson, AZBuilt 1975 · S/N 32-7540116 N3369WBlue Sky Aviation LLC · Attleboro, MABuilt 1968 · S/N 32-1054 N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098 N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175 N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489 N3370WRaddohl Garret L · New London, MNS/N 32-216 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N33720Westerhold Wayne · Cary, NCS/N 28R-7535182 N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N3372MFarah Michael J · Mclean, VABuilt 1980 · S/N 28-8011059 N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184 N33735Mcenaney John E · Orlando, FLBuilt 1975 · S/N 28-7510058 N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N3374WMcfadyen Joseph P · Florence, SCS/N 32-220 N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187

Back to AD 87-08-08 R3