Registered aircraft · 72,001

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.

N17762Hightower Group Holdings LLC · Dallas, TXBuilt 1982 · S/N 28-8390023 N17763Kahanek Sylvester S · Deer Park, TXBuilt 1979 · S/N 28-8090179 N1776JTafaghodrad Arash · Chandler, AZBuilt 1968 · S/N 28-24198 N1776TSota Charles G Jr · Kirkland, WABuilt 1970 · S/N 28-7125093 N1776URegistration Pending · Boulder City, NVRegistration pendingBuilt 1975 · S/N 32R-7680024 N1777AJohnson Ross E · Midway, UTBuilt 1979 · S/N 28-7911320 N1777CHarlan Benjamin L · Madison, KSBuilt 1967 · S/N 28-23490 N1777JHoward David Patrick · Thomasville, NCBuilt 1968 · S/N 28-24199 N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555 N1777VFlying Colors Airparts Inc · Leesburg, FLBuilt 1987 · S/N 0623 N1778YWade Jason E · Salem, INBuilt 1966 · S/N 28-22261 N1779JMidwest Aviators · Robinson, ILS/N 28-24202 N1779PWilliamson Gary T · Ashmore, ILBuilt 1954 · S/N 22-2552 N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284 N177AFMcgee Aviation LLC · Yorktown, VABuilt 1984 · S/N 60-8423022 N177AGHerrington William N · Milton Freewater, ORFirst renewal noticeBuilt 2008 · S/N 5885 N177AKBrockman Kenneth E Jr · Iliamna, AKBuilt 2000 · S/N 2071 N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967 N177AWFarni Edward C III · Billings, MTBuilt 1970 · S/N 17701516 N177BCCraig William Richard · Vandalia, OHBuilt 1972 · S/N 17701803 N177BGAccurso Steven M · Marietta, GAS/N 17702449 N177BHAircraft Trade Group LLC · Scandia, MNS/N 17701411 N177BLMontgomery David · Oak Park, ILBuilt 1976 · S/N 17702425 N177BWRegistered aircraftBuilt 1972 · S/N 17701756 N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654 N177CMRapid Cloud Aviation LLC · Waxhaw, NCBuilt 1978 · S/N 32R-7887273 N177CVZinkel Gregory S · Leander, TXS/N 17700640 N177DBarger Randall G · Newport News, VABuilt 1973 · S/N 17702012 N177DAParry Thomas J · White Post, VABuilt 1977 · S/N 17702617 N177DFAllen Douglas J · Fallbrook, CABuilt 1981 · S/N 32-8124022 N177DKKeen David S · Amherst, NHBuilt 1967 · S/N 17700567 N177DPPerkins Dimmitt J · Sheridan, ARBuilt 1976 · S/N 02 N177EBDodd Lisa · Sandpoint, IDBuilt 1967 · S/N 17700562 N177EELiebeler Susan Trustee · Malibu, CABuilt 1976 · S/N 17702511 N177EJDouble A Flight Services LLC · Edinburg, TXBuilt 1971 · S/N 17701626 N177ETThorstad Aviation LLC · Alexandria, MNBuilt 1976 · S/N 17702378 N177EWMidwest Bush Co LLC · New Strawn, KSBuilt 1996 · S/N 23177 N177FDSale Reported · Bowling Green, KYSale reportedBuilt 1967 · S/N 680040 N177FGMancini Joseph · Alpine, CABuilt 1968 · S/N 17700817 N177FJInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 17702122 N177FRLandrum David W · Hot Springs, ARBuilt 1974 · S/N 17702135 N177GBHess Robert E · Rockford, ILBuilt 1975 · S/N AA5B-0123 N177GLRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1974 · S/N 17702177 N177GSAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701845 N177GTWoischke Robert B · Schaumburg, ILBuilt 1973 · S/N 17702052 N177GWMarquette County Flying Club · Marquette, MIBuilt 1976 · S/N 17702481 N177HCQualitair LLC Trustee · MichaelstadtBuilt 2001 · S/N 4636314 N177HLLuken Henry G III · Chattanooga, TNS/N 17701106 N177HWCentral Virginia Aviation Inc · Petersburg, VAS/N 17701482 N177JFIsr Aviation LLC · Wilmington, DEBuilt 1975 · S/N 17702259

Back to AD 87-10-06 R1