Skip to content

Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

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 N5576LMartin Richard W · Raymore, MOBuilt 1981 · S/N 549 N5576PMark Stephens Farm Inc · Dutton, MTBuilt 1958 · S/N 24-640 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 N5577CCoady Chad M · Taylorville, ILBuilt 2021 · S/N 81991 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 N5578FJarvis Trent A · Apo, AEBuilt 1972 · S/N FA-200-180 N5578QLyon Scott T · Wellsville, KSBuilt 1965 · S/N 642 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 N5579PBucciarelli Dominick F · Pueblo, COBuilt 1958 · S/N 24-643 N5579UInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-26887 N5579YHepner Glenn L · New Port Richey, FLBuilt 1964 · S/N 27-2684 N557DCJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1630 N557DJMclain Aviation LLC · Lyons, GABuilt 1973 · S/N 17262420 N557DTRedace LLC · New York, NYBuilt 1985 · S/N 28-8690022 N557HRJohnston Philip R · Highland, CABuilt 2005 · S/N 34 N557JBWages Zachary A · Pottstown, PABuilt 1999 · S/N 21318 N557KVSanders Kevin L · Round Rock, TXBuilt 2020 · S/N 83148 N557PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842094 N557RRCuller David A Jr · Virginia Beach, VABuilt 1997 · S/N 3511 N557SWMarshall John F III · Sterling Heights, MIBuilt 1968 · S/N 28-25193 N557TBAirborn Flight Services Inc · Farmingdale, NYBuilt 1995 · S/N 1726 N557XBirkelbach Steven Wayne · Pilot Point, TXBuilt 2006 · S/N 20864 N557XWGiesecke Stephen A · Shelton, WABuilt 2006 · S/N 70030 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 N5580PJustice Nell E · Palmdale, CABuilt 1959 · S/N 24-644 N5580WSmitty 172 LLC · Rockford, MIS/N 28-691 N55811Scott Tyler C · Ball Ground, GABuilt 1973 · S/N 28-7325490 N55816Flying Manatees LLC · Wilmington, DEBuilt 1973 · S/N 28-7325492

Back to AD 87-10-06 R1