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.

N451ATMaxflight Helicopter Services Inc · Kissimmee, FLBuilt 2021 · S/N 2636 N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645 N451BTNeosho Investments LLC · Neosho, MOBuilt 1967 · S/N 28-23951 N451CDDull Kevin M · Northlake, TXBuilt 1978 · S/N AA5B0995 N451DDJth Holdings LLC · Flemingsburg, KYBuilt 1990 · S/N 1451 N451GRMidwest Kilo Delta LLC · Clara City, MNS/N 1408 N451JSend North · Anchorage, AKBuilt 1965 · S/N 32-254 N451JRFathom Aviation LLC · Burley, WAS/N 65-0212 N451KWKw Plastics · Troy, ALBuilt 1978 · S/N 451-78 N451MCAero-Tech Helicopters LLC · Kingstree, SCS/N 340287 N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76 N451SABobbitt Cole T · Jasper, GABuilt 2004 · S/N 944-2004 N451TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020140 N451WSG&S Property Management LLC · Saint Ignatius, MTS/N 10338 N451XCross Winds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-7911129 N452Chace Stephen B · Bloomington, ILBuilt 1986 · S/N 632 N45204Markelov Sergey · Naperville, ILBuilt 1979 · S/N AA5B1067 N45208Bunker Wayne M · Cape Carteret, NCBuilt 1979 · S/N AA5B1069 N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827 N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060 N4520JRegistered aircraftBuilt 1968 · S/N 28R-30377 N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062 N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063 N4520RBurge John A · Pensacola, FLS/N 28-21222 N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216 N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076 N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077 N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071 N4521JSpringer Louis A · Bellflower, CAS/N 28R-30378 N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072 N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073 N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223 N4521TSpencer Kevin L DBA · Bend, ORBuilt 1972 · S/N 28R-7235077 N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075 N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023 N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072 N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088 N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089 N4522ABryant Stephen · Anchorage, AKS/N 22-3829 N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081 N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084 N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085 N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028 N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030 N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087 N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467 N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091 N4523JN4523j LLC · Wilmington, DEBuilt 1968 · S/N 28R-30381 N4523RGardner Michael J · Ashland, ILS/N 28-21225 N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112

Back to AD 87-10-06 R1