Skip to content

Registered aircraft · 22,416

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.

N8698NUnder Bridge LLC · Wilmington, DEBuilt 1971 · S/N 32-7240045 N8699NHolding Short LLC · Travelers Rest, SCBuilt 1971 · S/N 32-7240047 N869BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020269 N869GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881468 N869MAGoose Aviation Co · Farmingdale, NYS/N 28-8316060 N869TASheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881545 N86AJMullins Mark C · Riverside, CABuilt 1972 · S/N 32-7200036 N86AYN86ay LLC · Burke, VABuilt 1977 · S/N 32R-7780478 N86CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 32-40957 N86ECParisi Mario · Grosse Ile, MIS/N 28-7525026 N86FEBeardslee William C Jr · Marblehead, MAS/N 28-8611007 N86HCN86hc LLC · Rochelle, ILBuilt 1997 · S/N 3257025 N86PFCti Aircraft Leasing LLC · Memphis, TNS/N 2881299 N86SUHeavenly Realms Aviation LLC · Grand Junction, COBuilt 2005 · S/N 2844122 N86TUFosaaen Karl · Albany, ORBuilt 1979 · S/N 28-7916535 N8700NJones Jaycob Paul · Arlington, TXS/N 28-25520 N8701NFuellner Frederick E · Shelocta, PABuilt 1969 · S/N 28-25521 N8702WRegistration Pending · Edgewood, NMRegistration pendingBuilt 1964 · S/N 28-10221 N8705NMay Randy S · Carrollton, TXBuilt 1969 · S/N 28-25526 N8705WLake Kenneth M · Manchester, MOBuilt 1964 · S/N 28-10238 N8708WLewellen Mark A · Pensacola, FLBuilt 1964 · S/N 28-10241 N870AMMojo Medical LLC · Webb City, MOBuilt 2004 · S/N 2843604 N870MAMaverick Flight LLC · Dover, DEBuilt 1977 · S/N 28-7790529 N870NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881921 N870PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881337 N8710EYuhasz Damon R · East Brunswick, NJBuilt 1976 · S/N 28-7610088 N8711WMatus Joe · Watsonville, CABuilt 1964 · S/N 28-10245 N8712EBec Industries LLC · Toms River, NJS/N 32-7600011 N8712NCook Jeffery M · Lakewood, WABuilt 1969 · S/N 28-25612 N8713COlsen Crosby J · Bainbridge Island, WABuilt 1976 · S/N 28-7625127 N8713WTree Star Aviation LLC · Greeneville, TNS/N 28-10247 N8714NHatch Joseph B · Mesa, AZBuilt 1969 · S/N 28-25615 N8715CDarcy Aviation LLC · Danbury, CTBuilt 1976 · S/N 28-7615124 N8715NKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1969 · S/N 28-25617 N8716NWeiss Ariel · Bisbee, AZBuilt 1969 · S/N 28-25618 N8716WIts Just Plane Fun LLC · Gilbert, AZBuilt 1964 · S/N 28-10251 N8718NKelly Bradford S · Bedford, NHBuilt 1969 · S/N 28-25623 N8718WB Max Aviation LLC · Mesa, AZBuilt 1964 · S/N 28-10253 N871ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881387 N871DCFinal Approach Inc · Newark, DEBuilt 1980 · S/N 28R-8131073 N871DMId Air LLC · Apopka, FLBuilt 1975 · S/N 28R-7535147 N871MAN2634mm LLC · Farmingdale, NYBuilt 1979 · S/N 28-7916512 N871MSLackey Christopher Donald · Helotes, TXBuilt 1981 · S/N 28R-8131167 N8720FWaters Lindsay R · Deland, FLBuilt 1976 · S/N 32R-7780113 N8720NHogan David A · La Crosse, WIBuilt 1969 · S/N 28-25532 N8720WKerklo Michael W · Seville, OHBuilt 1964 · S/N 28-10255 N8721NCobe Aviation LLC · Miller, SDBuilt 1969 · S/N 28-25533 N8722NKrueger Sandra J · Chicago, ILBuilt 1969 · S/N 28-25534 N8723COracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690159 N8723ECronk Howard J · Council Bluffs, IABuilt 1976 · S/N 28-7625150

Back to AD 87-08-08 R3