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.

N6598JThatcher Bruce Lyall · Shorewood, MNBuilt 1968 · S/N 28-5057 N6599JCormack Matthew S · Chandler, AZBuilt 1968 · S/N 28-5058 N659APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843771 N659DEEisenhauer Dwight · Lehighton, PAS/N 28R-35232 N659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeS/N 28-7125577 N659FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020184 N659KWWoods Kevin E · Albrightsville, PABuilt 1974 · S/N 28-7415515 N659NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881286 N65BDGuaranteed Overnight Cargo LLC · Miami, FLBuilt 1975 · S/N 32R-7680083 N65CNJohnston Charles Wc Jr · Newfield, NJS/N 28R-35111 N65CWFranks Cory · Idalou, TXBuilt 1989 · S/N 3213024 N65FCColdpatrol LLC · Mount Pleasant, SCBuilt 1977 · S/N 32-7740094 N65KFCrestwood Aviation LLC · Schererville, INBuilt 1968 · S/N 28R-30906 N65RJAdvantage Flight Training And Services LLC · Warren, ARBuilt 1965 · S/N 28-2599 N6601JRobinson John H · Kernersville, NCBuilt 1968 · S/N 28-5061 N6601WAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 28-20692 N6602JD14 Flight Club Inc · Manteno, ILBuilt 1968 · S/N 28-5062 N6602YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 28-21943 N6603JWorkman Karen L · Northfield, MNBuilt 1968 · S/N 28-5063 N6604FEvolution Air LLC · Huntley, ILBuilt 1976 · S/N 28-7715169 N6604WSedberry Jason A · Kokomo, INBuilt 1965 · S/N 28-20697 N6605FPurdue Aviation LLC · West Lafayette, INBuilt 1976 · S/N 28-7715171 N6605JPatton Janet · Denton, TXBuilt 1968 · S/N 28-5066 N6605WChadwick Joseph G · Fayetteville, GABuilt 1965 · S/N 28-20698 N6606FWestfall William L · Sunbury, OHBuilt 1976 · S/N 28-7790156 N6606JSale Reported · Warner Robins, GASale reported, canceledBuilt 1968 · S/N 28-5067 N6606WMobley Ray M Jr · Midlothian, TXS/N 28-20700 N6608JGreat Lakes Aviation Services Inc · Kimball, MIBuilt 1968 · S/N 28-5070 N6608WGrant Hooks LLC · Middleburg, FLBuilt 1965 · S/N 28-20702 N660AAFms Bank · Fort Morgan, COBuilt 2019 · S/N 2881255 N660FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020185 N6610JSaracoff Norman L · Neillsville, WIBuilt 1968 · S/N 28-5072 N6610WHattersley Donald C · York, SCBuilt 1965 · S/N 28-20704 N6611WBryant Bryce Nicholas · Crothersville, INBuilt 1965 · S/N 28-20705 N6613WBanks Jeffrey G · Columbus, OHBuilt 1965 · S/N 28-20707 N6615JAeropenn Aviation Academy LLC · Paxinos, PAS/N 28-5079 N6615WLoughridge Steven L · Montezuma, OHBuilt 1965 · S/N 28-20710 N6616JBrack Enterprises LLC · Indianapolis, INBuilt 1968 · S/N 28-5081 N6618WLe Ariya · La Crosse, WIBuilt 1965 · S/N 28-20713 N6619JBjelland Nathan D · Phoenix, AZBuilt 1968 · S/N 28-5085 N661DCParts Catalog Holding LLC · Clearwater, FLBuilt 1977 · S/N 28R-7703244 N661FLS B Enterprise LLC · Marshall, TXBuilt 1971 · S/N 28-7125581 N661FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020186 N661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 2890028 N661NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881287 N661PBravo Tango LLC · Minden, LABuilt 1980 · S/N 32R-8029080 N661WJff Air LLC · Dalton, GABuilt 1984 · S/N 32R-8429008 N6621JMardis David P · Warner Robins, GABuilt 1968 · S/N 28-5087 N6621WGbg Aviation LLC · Foristell, MOBuilt 1965 · S/N 28-20717 N6622JBernstein Matthew D · North Charleston, SCBuilt 1968 · S/N 28-5089

Back to AD 87-08-08 R3