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.

N3604XJones Bryan David Kingsley · San Diego, CABuilt 1977 · S/N 0767 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609 N3605HChilders Matthew W · Scottsdale, AZBuilt 1977 · S/N 20-1242 N3606EMiller Robert J · Casselton, NDBuilt 1978 · S/N 17271604 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N3606ZLandreth Homer W · Peoria, AZBuilt 1960 · S/N 22-7494 N36071Aero Systems Consultants Inc · Tulsa, OKBuilt 1978 · S/N 32R-7885155 N36073M C Aviation Holding Co LLC · Bryan, TXBuilt 1978 · S/N 32R-7887021 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3607EPalm Cedric C · St Francisville, LABuilt 1978 · S/N 17271605 N3607QToole William Barry · Goochland, VABuilt 1967 · S/N MA-207 N3607WOceanstate Flying Club Inc · Little Compton, RIBuilt 1966 · S/N 32-506 N3607XAldrich Roy · Webster, SDS/N 5081 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N3608WHand Andy A · Waco, TXBuilt 1966 · S/N 32-507 N3608ZBingman William A · Depoe Bay, ORBuilt 1960 · S/N 22-7496 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N3609EBismarck Aero Center Corp · Bismarck, NDBuilt 1978 · S/N 17271606 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N3609QNorthern Aviation LLC · Palmer, AKBuilt 1977 · S/N 32R-7780319 N3609WConverse James Robert · Port Saint Lucie, FLBuilt 1966 · S/N 32-509 N3609ZVeal Petra L · Sterling, AKBuilt 1960 · S/N 22-7497 N360AJAngle Of Attack LLC · Waynesville, OHS/N 25089 N360AMAhlgren Jon E · Juneau, AKBuilt 2015 · S/N 104M N360BBWhittier Lavoy A Bucky · Twin Falls, IDBuilt 2000 · S/N 708-320-552FB N360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913 N360BHRybczynski Douglas R · Chandler, AZBuilt 1995 · S/N 001 N360BJCode Supplies Inc · Rossville, TNBuilt 2026 · S/N PA 206 N360BSChampagne Patrick D · San Angelo, TXBuilt 1959 · S/N 18-6869 N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519 N360CRFree Man Airshows Ltd · Lyons, COS/N 865-320-662 N360DPSiebert Mcmahon LLC · Kalispell, MTBuilt 1994 · S/N 20084 N360EMAg Flyers Inc · Torrington, WYBuilt 1994 · S/N 20916 N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010 N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060 N360GJYoung Matthew · Conroe, TXBuilt 1995 · S/N 21735 N360GLLaznicka Garry V · Saint Charles, MOS/N 974-320-814CSFB N360GMMcdaniel Gary D · Kansas City, MOBuilt 1996 · S/N 3492 N360GTBrannigan Vanessa D · Morganton, NCBuilt 1995 · S/N 688-320-432FB N360HCMountain Air Spray Co Inc · Craig, COBuilt 1952 · S/N 18-1868 N360HUParker John J · Hamilton, MTBuilt 1996 · S/N 1341 N360JRahz Caleb G · Cuyahoga Falls, OHBuilt 1996 · S/N 774-320-616 FB N360JH360jh LLC · Pompton Plains, NJBuilt 1992 · S/N 580 N360JWWomack Jay A · Jackson, LABuilt 1992 · S/N 200-031 N360KLCarrara Dean E · Aiken, SCS/N 1 N360KMOgston Kai D · Colbert, WABuilt 2009 · S/N 001 N360KSSavier Helmut Klaus · Santa Paula, CABuilt 2010 · S/N SEZ-1

Back to AD 87-10-06 R1