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.

N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188 N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039 N25179Strite Kenneth J · Xenia, OHBuilt 1976 · S/N 531 N2517RWaterfront Developers Inc · Hickory, NCBuilt 1969 · S/N 28-5640 N25186Soule Raymond · Wiscasset, MES/N 1156 N2518ARegistration Pending · Wasilla, AKRegistration pendingBuilt 1953 · S/N 18-2148 N2518GVintage Aviation Inc · Garden City, NYBuilt 1967 · S/N 166 N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N25190Wiley Calvin B · Summer Shade, KYBuilt 1940 · S/N 1011 N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881 N2519QWhite Shane A · Fayetteville, GABuilt 1991 · S/N 1155 N2519TDouglas James E · Fallbrook, CAS/N 949 N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N251AGHays Cory W · Beaumont, TXFirst renewal noticeBuilt 1976 · S/N 0001 N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426 N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99 N251DWWallin Aviation LLC · Taylorsville, UTBuilt 2004 · S/N T18208263 N251DYYbarra Daniel T · Westcliffe, COBuilt 2026 · S/N 42687-1 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N251ECMike Lima Partners LLC · Wilmington, DES/N 103 N251GJendair LLC · New York, NYBuilt 1977 · S/N 61P-0462-181 N251HFHaidar Aviation LLC · Dallas, TXBuilt 2025 · S/N JP001 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251MECavu Aircraft Group LLC · Green Cove Springs, FLBuilt 2000 · S/N 18280740 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251RBNewton Roger N Jr · Marrero, LABuilt 1984 · S/N 408 N251RGBunn Mary · Williamstown, WVBuilt 2008 · S/N 089 N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251TTTyson David · Lusk, WYBuilt 1997 · S/N 25013C N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N251WHTallmadge Brian · Prescott, AZBuilt 1994 · S/N 3251 N251YAnderson Michael A · Bowie, MDBuilt 2021 · S/N M-II-2510 N25219Octopus Flying Club Inc · Riverdale, MDS/N 970 N2521NOpen Heavens Aerospace LLC · Fort Gratiot, MIS/N 901 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N2521SSieberts Soren K · Anchorage, AKBuilt 1979 · S/N 18-7909152 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N2522Garella Craig W · Edwardsville, ILBuilt 2020 · S/N 42006 N2522APierce Stephan L · Graham, TXBuilt 1953 · S/N 22-830 N2522BRossman Brian · Valparaiso, INS/N 863 N2522DMiller Stephen · St Louisville, OHS/N 872 N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352

Back to AD 87-10-06 R1