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.

N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475 N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476 N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477 N2623BWalton Indy R · Soldotna, AKS/N 5160 N2623CDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N R18200179 N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959 N26240Gilmer Thomas · Deridder, LABuilt 1977 · S/N AA5A0478 N26244Clear Blue Aviation LLC · Melbourne, FLBuilt 1977 · S/N AA5A0480 N26247Royer Virgil P · Salem, ORBuilt 1977 · S/N AA5A0482 N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091 N2624NBoston Helicopters Inc · North Andover, MAS/N 0739 N2624PRobinson Eric C · Palmer, AKS/N 22-2960 N2624WWilkins James K · Owens Cross Roads, ALBuilt 1966 · S/N 966 N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819 N26255Wren Donald F · West Chester, OHBuilt 1977 · S/N AA5A0485 N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436 N2625SSierra Aviation LLC · Plaza, NDBuilt 1979 · S/N R18201350 N2625WPatton William D · Sheridan, WYBuilt 1966 · S/N 967 N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265 N2626BRodgers Patti · Apple Valley, CABuilt 2004 · S/N 90429 N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963 N26273Gasiorowski Mark A · Buford, GABuilt 1977 · S/N AA5A0500 N26278Bal-Air LLC · Boca Raton, FLBuilt 1977 · S/N AA5A0502 N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180 N2627MN2627m LLC · Rehoboth Beach, DEBuilt 1988 · S/N 755M N2627NCartwright Josh D · Salem, MOBuilt 1988 · S/N 0756 N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297 N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53 N2628PCraig Richard L · Sonoma, CAS/N 22-2965 N2628ZSipes Gary C · Livingston, TXBuilt 1988 · S/N 0773 N26292Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0508 N26294Dennen Corey M · Troup, TXS/N AA5A0509 N26297Hunter Danny L · Gulfport, MSBuilt 1977 · S/N AA5A0510 N26298Champaign Sharon E · New Holstein, WIBuilt 1977 · S/N AA5A0511 N26299Ferraris Robert · Tinton Falls, NJBuilt 1977 · S/N AA5A0512 N2629WHogan James C DBA · Cameron Park, CABuilt 1966 · S/N 970 N262ACLavelle Jeffrey · Kenmore, WABuilt 1996 · S/N 766-96 N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187 N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836 N262AMChapman Kevin Joseph · Williston, NDBuilt 2004 · S/N 2262 N262ASAerodata LLC · Ann Arbor, MIBuilt 1977 · S/N 31-7712102 N262CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881005 N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497 N262E349 Ez LLC · Yakima, WABuilt 1984 · S/N 262 N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621 N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854 N262ESBreshears Michael · San Antonio, TXBuilt 1986 · S/N 425 N262GCSlepica Michael · Oregon, WIS/N 32R-7985030 N262GGN262ggllc LLC · Reno, NVBuilt 1967 · S/N 28-10934 N262GRDr I T Help LLC · Cheyenne, WYBuilt 1996 · S/N 21387

Back to AD 87-10-06 R1