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.

N4288HHoogendorn Homer E · Wasilla, AKBuilt 1948 · S/N 14-78 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188 N4288ZAltobelli Matthew J · Dover, PABuilt 1967 · S/N 18-8601 N4289HGiguere Michael R · Danielson, CTBuilt 1978 · S/N 24-0696 N4289JMiller Curtis L · Brownstown, PABuilt 1967 · S/N 28-22654 N4289RShaughnessy Paul V Jr · Norwood, MABuilt 1969 · S/N 32-40665 N4289THohm Harold C · Chicago, ILBuilt 1971 · S/N 28-7205133 N428ACMckinley Nathan C · New Braunfels, TXBuilt 2000 · S/N 1288-2000 N428BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010046 N428CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8690 N428CTInda Trygve H · Sparks, NVBuilt 1979 · S/N 28-7911155 N428DDJulius Donald D · Rollins, MTBuilt 2011 · S/N 1407 N428DKKugler Donald W Jr · Baptistown, NJBuilt 2003 · S/N 80608 N428DMCochran Michael S · Centennial, COBuilt 1995 · S/N 428 N428DWArizona Cloudbusters Inc · Mesa, AZBuilt 2001 · S/N 172S8708 N428FClark Robert D · Bedford, NHBuilt 1969 · S/N 28R-35201 N428JGDr Rotors LLC · Mccall, IDBuilt 2003 · S/N 10168 N428JPCal Aircraft LLC · Lewes, DEBuilt 2004 · S/N 40.426 N428JSHoerr Stacy D · Taylor, MOBuilt 1993 · S/N 101 N428KWKangas Matthew S · Santa Cruz, CABuilt 1998 · S/N 24486 N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169 N428NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010014 N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476 N428PBVander Molen William L · Hudsonville, MIBuilt 2017 · S/N 6 N428RHegy Thomas R · Hartford, WIBuilt 1971 · S/N 244-H N428RAN428ra LLC · Hampshire, ILFirst renewal noticeBuilt 1978 · S/N 32R-7887121 N428RBHouser Blue D · Edgemoor, SCBuilt 1963 · S/N 128 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N428RVCunningham Gary R II · Satellite Beach, FLBuilt 2014 · S/N 40303 N428SGriffing Flying Service Inc · Port Clinton, OHBuilt 1980 · S/N 32-8106021 N428SPStar Flight LLC · Johns Creek, GABuilt 2003 · S/N 40.283 N428SXMann John Franklin Jr · Marietta, GABuilt 2014 · S/N 001 N428WAPhillips Jeffry T · Ellensburg, WABuilt 1989 · S/N BIERMAN 0001 N4290HOwen Toy C · Anchorage, AKS/N 14-94 N4290RLadet David E · Lavonia, GABuilt 1969 · S/N 32-40666 N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539 N42917Afmr Inc · Dover, DEBuilt 1991 · S/N 2691 N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95 N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656 N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036 N42920Sanders Craig A · Stockton, CABuilt 2006 · S/N 5762 N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406 N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45 N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4292RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 32-40669 N4292SD&D Design Manufacturing Inc · Oklahoma City, OKBuilt 1983 · S/N 32R-8329014 N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037 N4293HHelleberg John R · Centreville, VABuilt 1978 · S/N 24-0697 N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661

Back to AD 87-10-06 R1