Skip to content

Registered aircraft · 72,001

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.

N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443 N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452 N2613PBraun Daniel R · Damascus, ORS/N 22-2948 N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454 N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727 N2614GNorthern Air Inc · Bonners Ferry, IDBuilt 1967 · S/N 64 N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292 N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455 N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456 N26165Moldt Richard W · Montrose, CAS/N AA5A0457 N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461 N2616WDenney David W · Fowler, COBuilt 1965 · S/N 962 N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465 N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468 N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707 N2617ZCroy Branden J · Kendallville, INBuilt 2001 · S/N 1301 N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954 N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771 N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955 N2619WSmith Cecil · Fort Pierce, FLS/N 963 N261AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843789 N261AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281186 N261BWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020253 N261CCCook Christopher · Columbus, GABuilt 2019 · S/N 82373 N261DMOelmann Dennis J · Waverly, IAS/N 379 N261ERCentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1362-133 N261EZZokpodo Emmanuel K · Sacramento, CABuilt 1975 · S/N 28R-7635087 N261FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020259 N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697 N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2 N261KTFrisch Adam · Los Angeles, CAS/N 61P-0437-163 N261MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881311 N261MMCockroft Scott · Kersey, COBuilt 2000 · S/N 30015C N261RMOlandese Donald J · Newalla, OKBuilt 2011 · S/N 91507 N261RSNational Aviation Partners LLC · Weatherford, TXBuilt 1972 · S/N 32-7340056 N261VFBickley Clarence R · Jefferson, GABuilt 1989 · S/N 576R N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239 N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471 N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725 N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091 N2621KBasmajian Zachary Robert · Peoria, AZBuilt 1954 · S/N 54-2629 N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297 N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202 N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559 N26225Kilday Klayton D DBA · Dexter, ORBuilt 1989 · S/N 1138 N2622HBurgess John H · Tower, MNS/N 001 N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735M N2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823 N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295 N26234Compositec Inc · Manitowoc, WIS/N AA5A0458

Back to AD 87-10-06 R1