Registered aircraft · 72,007

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.

N3586XPops Aviation Inc · Spartanburg, SCBuilt 1980 · S/N 31-8012070 N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809 N3587PMsm587p LLC · Jericho, NYS/N 31-8052120 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543 N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680 N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139 N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134 N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646 N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N3589WCfi Aero LLC · Riverside, CABuilt 1966 · S/N 32-484 N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358BHKelley Zachary · Anchorage, AKBuilt 2019 · S/N 1028 N358BTRorabaugh Kenneth P · Sunrise, FLS/N 32-40051 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510 N358ELCub Crafters Inc · Yakima, WABuilt 1996 · S/N E1 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358JCDuran Peter F · Mesa, AZBuilt 1993 · S/N 058B N358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913 N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358QO'Quinn Shannon L · Ridgeland, SCBuilt 2023 · S/N 42146 N358RVDerby Kevin R · Clearwater, FLBuilt 1998 · S/N 22173 N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066 N358SPIscovich Angel L · Santa Barbara, CABuilt 1997 · S/N 22468 N358TBSlezak David · Davison, MIBuilt 1995 · S/N 1716 N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858 N358VAChapman James H · Mebane, NCBuilt 2013 · S/N 25218 N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417 N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143 N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144 N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545 N3590WAgoston Thomas M Trustee · Liberty Twp, OHBuilt 1966 · S/N 32-485 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108 N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704 N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647 N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692 N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705 N3592WFoothills Aviation Inc · Pickens, SCBuilt 1966 · S/N 32-488 N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161 N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693

Back to AD 87-10-06 R1