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.

N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N2910LBurger Walter F III · Sugar Land, TXBuilt 1967 · S/N 670304 N2910XTallman Richard E · Lykens, PABuilt 1967 · S/N 17700310 N2911Dewinter Thomas A · Waunakee, WIBuilt 1968 · S/N 86 N2911GOrtega Rolando J · Sanford, FLBuilt 1979 · S/N 28-7916537 N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311 N2912MHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 28-7890279 N2912PJackson Robert S · Gallatin, TNBuilt 1955 · S/N 22-3180 N2912XAmbler Carlos S · Mendota, ILBuilt 1987 · S/N 1025 N2912ZFord Charles D · Clifton, TNBuilt 1959 · S/N 22-6882 N29131Kelly Alex · Arlington, VTBuilt 1987 · S/N 1027 N2913ATruesdell Shannon · Stephenville, TXBuilt 1988 · S/N 1062 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107057 N2914AAvier LLC · Beverly, MABuilt 1979 · S/N 28-7916538 N2914BWhite And Blue Wings LLC · Oakland Park, FLBuilt 1979 · S/N 28-7916539 N2914GSchubert Matthew · Belleair Beach, FLBuilt 1979 · S/N 28-7990551 N2914LPanalucent LLC · Saint Petersburg, FLBuilt 1967 · S/N 670486 N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334 N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182 N2914QEast High Flying · Othello, WABuilt 1987 · S/N 1028 N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327 N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884 N29157Midwest Aero Inc · Bay City, MIBuilt 1979 · S/N 32-7940130 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N2915GWalls Properties LLC · Paragould, ARBuilt 1979 · S/N 28-7911243 N2915LZorro Stephen · Rocklin, CABuilt 1967 · S/N 670309 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916LPospisil Thomas · Rockwood, PABuilt 1967 · S/N 670310 N2916WPilots Flying School LLC · Manalapan, NJBuilt 1979 · S/N 44-7995300 N29170Kuhlmann Connor · Ada, MIBuilt 1979 · S/N 32-7940131 N29172Reutter David C · Mount Kisco, NYBuilt 1979 · S/N 32-7940132 N2917LDobbs J S · Medford, ORBuilt 1967 · S/N 670311 N2917PRegistered aircraftBuilt 1955 · S/N 22-3185 N2917RCzarnecki Neil A · Racine, WIBuilt 1969 · S/N 28R-35328 N2917ZRegistration Pending · Granby, MORegistration pendingBuilt 1959 · S/N 22-6887 N2918DMelton Derrick · Midland, TXBuilt 1979 · S/N 28-7911245 N2918EDelpenn Flyers Inc · Dover, DEBuilt 1978 · S/N 17271372 N2918LHieb Jared J · Amarillo, TXBuilt 1987 · S/N 1030 N2918PLafferty Eric M · Anchorage, AKBuilt 1955 · S/N 22-3186 N2918VLinse Shane G · Billings, MTS/N 134 N2918XFlight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-7916543 N2918ZLarson David R · Boerne, TXS/N 22-6888 N2919ZPankonin Steve B · White City, ORS/N 22-6889 N291ACBennett Mark A · Normangee, TXBuilt 2000 · S/N 1285-99 N291CAMaya Air Services LLC · Lee, NHBuilt 2004 · S/N 1373-2004 N291CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881007 N291DMMiller Jerry L · Garrison, NDBuilt 1999 · S/N 405-99 N291DSPetko James G · Mishawaka, INS/N 001

Back to AD 87-10-06 R1