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.

N81344November 46a Leasing Inc · St Augustine, FLBuilt 1980 · S/N 28-8016169 N8134WBrilliant Holdings LLC · Winfield, MOS/N 28-2245 N8135CCoverdale Aviation LLC · Ellendale, DEBuilt 1979 · S/N 28-8016173 N8135GMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016175 N8135PStein David J · New Port Richey, FLBuilt 1979 · S/N 28-8016176 N8135WWoodrum Alan D · Danville, ILBuilt 1965 · S/N 28-2246 N8136JRiti Inc · Jackson, TNBuilt 1979 · S/N 28-8090173 N8136QVenture West LLC · Mesa, AZBuilt 1979 · S/N 28-8090174 N8136WNajjar Craig S · Norwood, MABuilt 1965 · S/N 28-2249 N8136YMatkowski Tyler Trustee · Winter Garden, FLBuilt 1979 · S/N 28-8011048 N8137AKastengren David A · Cherokee, IABuilt 1979 · S/N 28-8011049 N8137CPeterson Alan P · Walla Walla, WABuilt 1979 · S/N 28-8011050 N8137DLee'S Mobile Service Inc · Holt, MOBuilt 1979 · S/N 32-7940273 N8137HLimitless Horizons Sevierville LLC · Seveirville, TNS/N 32-7940274 N8137QUnited States Air Force · Hanscom Afb, MABuilt 1979 · S/N 28-8016179 N8137UMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016181 N8137VAeolus Aviation LLC · River Hills, WIBuilt 1980 · S/N 32R-8029003 N8138HAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090178 N8138WSky Air Inc · Cedar Rapids, IABuilt 1965 · S/N 28-2251 N8138YBelmont Aviation LLC · Port Saint Lucie, FLBuilt 1979 · S/N 28-8090180 N8138ZAljundi Bassam S · Germantown, TNBuilt 1979 · S/N 28-8011051 N8139FStegall Ashley V · Daphne, ALBuilt 1979 · S/N 32R-8013043 N8139HAmerican Heritage Aviation Inc · Peachtree City, GAS/N 28R-8018025 N8139WHigh Five Flight Inc · Dawson, NEBuilt 1965 · S/N 28-2252 N813CTDoolley Flyers LLC · Harvard, MABuilt 1985 · S/N 28-8590080 N813DCJ & J Aviation Holdings LLC · Dallas, TXBuilt 1999 · S/N 2843280 N813DKRobinmith Aero Inc · Emerson, IABuilt 1980 · S/N 32R-8013103 N813DLBoys Out Flying LLC · Stevens Point, WIBuilt 1977 · S/N 32R-7880003 N813JMKohler James M · Newark, DES/N 32R13006 N813JSDiamondhead Aviation LLC · Omaha, NES/N 32R-8229034 N813NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 2837044 N813PBunn Dennis E · Wilson, NCBuilt 1979 · S/N 28-7990589 N813SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881714 N813SSLake In The Hills Aviation LLC · Algonquin, ILBuilt 1974 · S/N 28-7415543 N81406Dorgate LLC · Charles City, IABuilt 1982 · S/N 28-8211028 N8140EProppe Karl H · Needham, MABuilt 1982 · S/N 28R-8218012 N8140PMcgee Edward · Pompano Beach, FLBuilt 1980 · S/N 28-8011081 N8140QOlson Andrew John · Vail, AZBuilt 1980 · S/N 28-8011058 N8141REast Coast Foundation Specialists · Elkridge, MDBuilt 1982 · S/N 32R-8213032 N8141WParham Randy L · Saint Charles, MOBuilt 1965 · S/N 28-2254 N8141ZFbni Inc · Oakland, MDBuilt 1979 · S/N 28-8016240 N8142HC & T Aviation Holdings Inc · Mckinney, TXBuilt 1982 · S/N 28-8216118 N8142KHesseltine Robert J · Grand Terrace, CABuilt 1982 · S/N 28-8216120 N81436P&C Construction Inc · Chattanooga, TNBuilt 1979 · S/N 32R-8029045 N8143HHahn Jeffrey L · Whitewater, WIBuilt 1982 · S/N 28-8290096 N8143WMartell Ryan · Madison Heights, VABuilt 1965 · S/N 28-2257 N81441Thomas Ramone O · Philadelphia, PABuilt 1979 · S/N 28-8016241 N8144ABrickbat Aviation LLC · Little Rock, ARBuilt 1979 · S/N 32-7940276 N8144GDistant Horizons LLC · Park City, UTBuilt 1979 · S/N 32R-8029047 N8144HMfr Aviation Inc · Wilmington, DEBuilt 1980 · S/N 32R-8013052

Back to AD 87-08-08 R3