Registered aircraft · 72,010

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.

N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034 N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237 N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162 N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850 N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044 N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915 N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011 N4496XJennings Matthew · Valley Center, CAS/N 28-7690022 N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166 N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851 N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051 N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045 N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869 N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412 N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916 N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020 N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239 N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042 N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023 N4498FSapit Corp · Los Banos, CABuilt 1976 · S/N 32R-7680453 N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919 N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045 N44990Fineran James V III · Towson, MDBuilt 1977 · S/N 32-7840002 N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054 N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920 N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022 N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911 N4499XCitrus Flight LLC · Lecanto, FLBuilt 1975 · S/N 32R-7680021 N449AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843798 N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344 N449ASConcho Aviation LLC · Sterling City, TXBuilt 2003 · S/N 10108 N449BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2013 · S/N 2265 N449BCMcbride Richard A · Deer Park, WAFirst renewal noticeBuilt 2007 · S/N 1681 N449CNSpeedo Air LLC · Hales Location, NHS/N 10431 N449DAArford Dennis C · Athens, GABuilt 2017 · S/N 22124 N449DMMccord David B · Chico, CABuilt 1998 · S/N 001 N449EWWilliams Ethan B Trustee · Wasilla, AKBuilt 2012 · S/N 001 N449FAAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3683 N449JGHerlihy John J · Arroyo Grande, CABuilt 1979 · S/N 61P06567963304 N449LMontana Hotel LLC · Providence, UTBuilt 1993 · S/N 2075 N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185 N449PMMullenbach Michael R · Saint Ansgar, IABuilt 1999 · S/N 1466 N449PSMid Atlanta Air Museum · Reading, PABuilt 1974 · S/N 12449 N449RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020198 N449RVRobinson Stewart · San Jacinto, CABuilt 1998 · S/N 20449 N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315 N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773 N44ABAnthony Ronald W · Claremont, CABuilt 1975 · S/N 22-1196 N44ACFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 31-8052147 N44ADTice Logan Edward · Noblesville, INBuilt 1979 · S/N 123AD

Back to AD 87-10-06 R1