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.

N260CJohnson Thomas G Jr · Morganton, NCBuilt 1965 · S/N 28-10680 N260CSRegistration Pending · Kodiak, AKRegistration pendingBuilt 1975 · S/N 32-7500022 N260FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020258 N260FHFlorida Flyers · Jacksonville, FLBuilt 1965 · S/N 32-54 N260GPJs Doig Restoration LLC · Varnville, SCBuilt 1967 · S/N 32-873 N260NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842055 N260SWMattson Krister T · Onalaska, WIBuilt 1966 · S/N 32-541 N260UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020225 N260WGRegistered aircraftBuilt 1968 · S/N 32-1039 N2610RStable Aviation LLC · Eagan, MNBuilt 1969 · S/N 28R-35229 N2611MOlsen Robert F · Chatham, MABuilt 1977 · S/N 28R-7803138 N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443 N2617MBarrett Gaston W DBA · Philadelphia, MSBuilt 1977 · S/N 32-7840051 N261AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843789 N261BWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020253 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 N261FDSena Michael · Towanda, PABuilt 1979 · S/N 28-7921042 N261MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881311 N261RSNational Aviation Partners LLC · Weatherford, TXBuilt 1972 · S/N 32-7340056 N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297 N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202 N262CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881005 N262GCSlepica Michael · Oregon, WIS/N 32R-7985030 N262GGN262ggllc LLC · Reno, NVBuilt 1967 · S/N 28-10934 N262MGGeorgia Aviation Authority · Eastman, GAS/N 2881312 N262NDMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 2842061 N262R262r LLC · Richland, WABuilt 1966 · S/N 28-21931 N262SASundance Airport LLC · Yukon, OKBuilt 1967 · S/N 28-4047 N262XPrice Scott K · Sparks, MDBuilt 1973 · S/N 28R-7335286 N2634MN2634mm LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816298 N2634RRichardson Michael T · Inver Grove Hghts, MNS/N 28R-35236 N2635QAir-Mods Flight Academy · Robbinsville, NJBuilt 1977 · S/N 28-7716115 N263DHHybird Inc · Corpus Christi, TXBuilt 1982 · S/N 32R-8229067 N263MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881361 N263NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842064 N2645QSigman Kenneth M · Birmingham, ALBuilt 1977 · S/N 28-7790411 N264AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881759 N264DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843825 N264DHPolymath Enterprises LLC · Incline Village, NVBuilt 1981 · S/N 32R-8129095 N264FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020260 N264MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881362 N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069 N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258 N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063 N2653TValley Aircraft Restoration Society Inc · Phoenix, AZBuilt 1971 · S/N 28-7210001 N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079 N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067 N2659TLeja Surveying Corp · Yucaipa, CABuilt 1971 · S/N 32-7240036

Back to AD 87-08-08 R3