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.

N5YPMo'S Ventures LLC · Lakeside, CABuilt 1974 · S/N 327440067 N5YTKilian Jacob J · Anchorage, AKBuilt 2005 · S/N RML001 N5YXRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1981 · S/N 17275266 N5ZMDakota & Skyy LLC · Louisville, COBuilt 1975 · S/N 0722 N5ZQHigher Powered Racing LLC · Port Saint Lucie, FLBuilt 2001 · S/N 612-320-358FB N5ZURegistered aircraftBuilt 1981 · S/N 18-8109005 N5ZWVinnola Bruce L · Glenrock, WYBuilt 2005 · S/N 109 N5ZYInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 468 N60003Faucette Douglas R · Fallon, NVBuilt 1978 · S/N M-2110 N60007Haynes Kevin Wayne · Pompano Beach, FLS/N MC-629 N6000BYahner William P · Central Square, NYBuilt 1978 · S/N M-2108 N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236 N6000QInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 3221 N6000TO'Neill Christopher M · Newark, OHBuilt 1973 · S/N 28-7310115 N6000WPort Townsend Aero Museum · Port Townsend, WABuilt 1963 · S/N 28-20000 N6000ZGillette David A · Monticello, UTBuilt 2001 · S/N 24142 N6001DJohnson Scott V · Scottsdale, AZBuilt 1956 · S/N 22-4652 N6001HHolmes Robert · Pittsgrove, NJBuilt 1978 · S/N MC-630 N6001PZarate Roger L · La Mirada, CABuilt 1959 · S/N 24-1095 N6001QCurry Gary · Everett, WABuilt 1965 · S/N 3222 N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118 N6001VNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N M-2112 N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119 N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120 N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122 N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123 N6002MDisilvestro Steven G · Wallkill, NYBuilt 1978 · S/N MC-633 N6002SSouthern Adventures Inc · Stuart, FLBuilt 1979 · S/N M-2115 N6002WPeppas George D Jr · Fort Wayne, INS/N 28-20002 N60030Jmj Properties LLC · Atchison, KSBuilt 2006 · S/N T18208500 N6003CMiles Darren · Bonita Springs, FLBuilt 1979 · S/N M-2113 N6003QOsborn John W · Cimarron, KSBuilt 1965 · S/N 3223 N6003RRemikin I LLC · Naperville, ILS/N ME-126 N6003USoarin Seven Aviation LLC · Morton, ILBuilt 1970 · S/N 28-26809 N6003WCarmon Walter A · Highland, NYS/N 28-20003 N6003XB&E Leasing LLC · Dubuque, IAS/N 1591 N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129 N6003ZPetranek John A · Mandeville, LAS/N M-2118 N60046Lee John C · Marietta, OHBuilt 1992 · S/N 14546 N6004QSmith Aviation Inc · Wilmington, DEBuilt 1965 · S/N 3224 N6004WDorr Martin E · Strongsville, OHBuilt 1978 · S/N M-2121 N6005QBittle Gary D · Bald Knob, ARBuilt 1965 · S/N 861 N6005UHaney William R · Pontotoc, MSBuilt 1970 · S/N 28-26906 N6005ZMarstall Nancy T · Asheville, NCBuilt 1978 · S/N M-2127 N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133 N6006WGreen William A · Memphis, TNBuilt 1964 · S/N 28-20006 N6007CAdler Jeffrey S Trustee · Westminster, COBuilt 1978 · S/N R18200348 N6007HPolice Facility Design Group Pa · Kansas City, KSBuilt 1993 · S/N 14593 N6007QRegistration Pending · Tampa, FLRegistration pendingBuilt 1965 · S/N 3225 N6007USteele Tucker L · The Colony, TXFirst renewal noticeBuilt 1970 · S/N 28-26817

Back to AD 87-10-06 R1