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.

N55719Coffey County Airport · Burlington, KSBuilt 1973 · S/N 287325467 N5571JHildebrandt Eric A · Cocoa, FLS/N 32-997 N55722Cactus Aero LLC · Haslet, TXBuilt 1973 · S/N 28-7305451 N55724Parker David G · Bristol, TNBuilt 1973 · S/N 28-7305452 N55726Diedeman Thomas A · Lake City, FLBuilt 1973 · S/N 28R-7335278 N5572UPoor Farmer Aviation LLC · Saint Marys, OHBuilt 1969 · S/N 28-26302 N5572VWood Charles S · Fox Island, WABuilt 1977 · S/N 28-7725241 N55730K&D Ip LLC · Chicago, ILBuilt 1973 · S/N 28-7325468 N55731Leary Dennis E · Chesapeake Beach, MDBuilt 1973 · S/N 28-7325469 N55736Fox Ralph W II · Wilmington, NCBuilt 1973 · S/N 28-7305373 N55738Wenner William E · Kechi, KSBuilt 1973 · S/N 28-7325473 N55739Kepfer Robert · Felton, DEBuilt 1973 · S/N 28-7305456 N5573WHokanson Elijah R · Ashby, MNS/N 28-668 N55742Doyal William T · Visalia, CABuilt 1973 · S/N 28-7325474 N55743B&R Aircraft LLC · Wadsworth, OHBuilt 1973 · S/N 28-7325475 N55744Williams Mike · Hartsville, INS/N 28-7325476 N55746Mccoy Michael E · Sanford, NCBuilt 1973 · S/N 28-7305459 N5574UCooper Nicholas A · Plano, TXBuilt 1969 · S/N 28-26303 N5574WNordell Ryan J · Roberts, WIBuilt 1962 · S/N 28-669 N55756Piper Aircraft Inc · Vero Beach, FLBuilt 1973 · S/N 28R-7335267 N5575FBrewington Jesse L · Glenallen, MOBuilt 1968 · S/N 28-25011 N5575JHarrison Matthew · Benton, ILBuilt 1968 · S/N 32-1036 N55761Ramirez Ramon E · Boynton Beach, FLBuilt 1973 · S/N 28-7305462 N55763Walker William L · Norfolk, MABuilt 1973 · S/N 28R-7335283 N55769Urban Joseph P · Ben Wheeler, TXBuilt 1973 · S/N 28-7325482 N5576JIndiana Wings Inc · Indianapolis, INBuilt 1976 · S/N 32R-7680447 N5576UChambers Luther · New Philadelphia, OHS/N 28-26305 N5576WKoch Christopher P · Batavia, NYBuilt 1962 · S/N 28-678 N55771Christman Timothy J · Stillwater, MNBuilt 1973 · S/N 28-7305464 N55776Jordan John R · Brawley, CABuilt 1973 · S/N 32-7340137 N5577FFederici Susan L · Vineland, NJBuilt 1968 · S/N 28-24910 N55780Sibayan Jose E · Lutz, FLS/N 28-7325483 N55783Djh Leasing LLC · De Pere, WIBuilt 1973 · S/N 28-7305467 N55785La Grange Aviation LLC · Bolingbrook, ILBuilt 1973 · S/N 28-7305469 N55786Calkins Mark · Nikiski, AKBuilt 1973 · S/N 28R-7335288 N5578UHolmes Robert G · Jacksonville, FLBuilt 1969 · S/N 28-26308 N5578WVigano Davide · Redmond, WABuilt 1962 · S/N 28-685 N55790Buzzard Aviation LLC · Pace, FLBuilt 1973 · S/N 28-7325487 N55792Ramocinski Carson · Prescott, AZBuilt 1973 · S/N 28-7305471 N5579FSeaplane Adventures LLC · Cheyenne, WYBuilt 1968 · S/N 28-24912 N5579JFlyinahrens LLC · Webster Groves, MOBuilt 1968 · S/N 32-1024 N5579UInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-26887 N557DTRedace LLC · New York, NYBuilt 1985 · S/N 28-8690022 N557PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842094 N557SWMarshall John F III · Sterling Heights, MIBuilt 1968 · S/N 28-25193 N55801Jacobs Michael A · Modesto, CABuilt 1973 · S/N 28-7325488 N55802Thomas Tommy A · Garden Grove, CABuilt 1973 · S/N 28-7305473 N55803Georgoulianos Anthanasios · Sweetwater, NJBuilt 1973 · S/N 28-7305475 N55804Angert Phillip · Linden, NJBuilt 1973 · S/N 28R-7335291 N55808Oltrogge Michael · Bancroft, NEBuilt 1973 · S/N 287305416

Back to AD 87-08-08 R3