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.

N4716WHall Joseph Syd · Beeville, TXBuilt 1976 · S/N 14046 N4717AOppegaard Craig E · Saint Louis Park, MNS/N 18-4935 N4717JBrock Aviation Flight School LLC · Douglasville, GABuilt 1966 · S/N MB-175 N4718KMayes John · Carson City, NVS/N R1722017 N4718LSnt Aviation LLC · Laurel, MSBuilt 1967 · S/N 28-4038 N4719AAvquest Aviation Services LLC · Montgomery, NYBuilt 1956 · S/N 18-4939 N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076 N4719LMinderman David J · Westlake, OHBuilt 1967 · S/N 28-4039 N4719WAc Airgroup LLC · Mckinney, TXBuilt 1976 · S/N 14049 N471AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843743 N471ACWard Allen M · Andalusia, ALBuilt 1998 · S/N 410-98 N471AKAkima Logistics Services LLC · Usaf Academy, COBuilt 2018 · S/N CC18-0090 N471AMWells Alex E · Bend, ORBuilt 2004 · S/N 2271 N471ATAirmen Testing & Training Inc · Lantana, FLBuilt 1987 · S/N 0737 N471DLSutton Douglas A · Paola, KSBuilt 1964 · S/N 28-10384 N471FJForeman Frank A · Call, TXBuilt 2011 · S/N 72325 N471GMHarland Willard G · Tuscumbia, ALBuilt 1979 · S/N R18201112 N471HCHinds Community College · Raymond, MSBuilt 2024 · S/N 28020199 N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933 N471KWheeler M Andrew · Westfield, INBuilt 2002 · S/N 471A N471MHHughes Michael J · Mayville, WIBuilt 2020 · S/N 767 N471NPGallant David A · Hartsel, COBuilt 1999 · S/N 22471 N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016 N471SPPine Ventures LLC · Malmo, NEBuilt 1998 · S/N 172S8014 N471VVlieg Roger W · Marianna, FLBuilt 1966 · S/N 28-10844 N47204Reinhardt Michael J · Tonawanda, NYBuilt 1977 · S/N 1499 N4720AP P & J LLC · Gillette, WYBuilt 1956 · S/N 18-4941 N4720FBennett Ronald W · North Pole, AKBuilt 1963 · S/N 18-7989 N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016 N4721LLee Christopher S Sr · Quinton, VABuilt 1967 · S/N 28-4043 N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017 N47225Aviation Partners Inc · Carson City, NVBuilt 1977 · S/N 28-7890050 N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158 N4722AJoos Devon T · Menlo Park, CABuilt 1956 · S/N 18-4943 N4722SStallman Jon · Chico, CABuilt 1996 · S/N 002 N4722WMurphy Patrick Ambrose · Altoona, IAS/N 14052 N4722YX-C Soaring Association Inc · Pensacola, FLBuilt 1967 · S/N 25-4465 N47232Lensis Thomas M · Wilmington, NCBuilt 1977 · S/N 32R-7880001 N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018 N4723TPrs Holdings Inc · Jurupa Valley, CABuilt 1981 · S/N R18201744 N4724JRegistration Pending · Orlando, FLRegistration pendingS/N MB-184 N4724PTnt Farms · Marana, AZS/N 27-252 N4725DClover Park Technical College · Tacoma, WABuilt 1979 · S/N 17272340 N4726ESky Hopper LLC · San Jose, CABuilt 1982 · S/N 18268262 N4726JPurves Patrick W · Brooklyn Park, MNBuilt 1966 · S/N MA-158 N4726SN4726s LLC · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-1165 N4726WEmenheiser Devin J · Elizabethtown, PAS/N 14056 N4727D4 Leaf Clover Leasing LLC · Murrieta, CABuilt 1979 · S/N 17272341 N4727JSindelar Kenneth L · Fremont, WIBuilt 1966 · S/N MB-185 N4727LTeton Anesthesia Ltd · Batesville, ARS/N 28-4051

Back to AD 87-10-06 R1