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.

N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075 N497LTRonneberg Dave H · Santa Monica, CABuilt 2010 · S/N L-002 N497SJFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8497 N49809Anderson Erik G · Deerfield Beach, FLBuilt 1976 · S/N 14055 N4980PLewis Clinton A · Antlers, OKBuilt 1963 · S/N 27-584 N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699 N4980TAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N R18201813 N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229 N4980ZElliott Charles · Rock Spring, GABuilt 1961 · S/N 22-8588 N4981GGillespie John · Austin, TXBuilt 1979 · S/N 17273528 N4981LBasinger Robert C · Freedom, PABuilt 1967 · S/N 28-4356 N4981PTri State Aero Inc · Martinsburg, WVBuilt 1963 · S/N 27-585 N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701 N4981VWasatch Industries LLC · Ogden, UTS/N 172RG0444 N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301 N4982EDevrnja Aero LLC · Knoxville, TNBuilt 1978 · S/N 17271686 N4983FSkyventure Avaition LLC · Battle Creek, MIS/N 17273115 N4983GBrouillard Mark R · Avon, INBuilt 1979 · S/N 17273530 N4983LDecoster Vaughn A · Greenwood, ARBuilt 1967 · S/N 28-4358 N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303 N4983YCaprock Soaring Association · Lubbock, TXBuilt 1968 · S/N 25-4787 N4984FChuprinko John A · Centerburg, OHBuilt 1977 · S/N 14246 N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738 N4984PMoore Bruce W · Aledo, TXBuilt 1964 · S/N 27-588 N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047 N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704 N4984TBoggs Investments Air Div LLC · Fredericksburg, VABuilt 1972 · S/N 28-7225302 N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739 N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167 N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740 N4986LFarrah Gabriel E · Avon, CTBuilt 1967 · S/N 28-4361 N4986PLms Aviation LLC · Omaha, NEBuilt 1964 · S/N 27-590 N4987JFulco Jason E · Frisco, TXS/N 28R-30742 N4987NWhite Jake W · San Antonio, TXBuilt 1979 · S/N 2 N4987PRegion Flyers LLC · Valparaiso, INBuilt 1964 · S/N 27-591 N49886Boon Bradley A · Greenwood, WIBuilt 1962 · S/N 28-1010 N4988LAnson Flyers Club Inc · Wadesboro, NCBuilt 1967 · S/N 28-4362 N4988YVan Kleek Steve D · Milford, IABuilt 1968 · S/N 25-4797 N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744 N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447 N498CFBosely Thomas L · Tavernier, FLBuilt 1998 · S/N 5678 N498CMRoberts Mark · Tecumseh, MIBuilt 2007 · S/N 82208 N498ECEllie Belle Aviation LLC · Marietta, GABuilt 2013 · S/N 41240 N498FLOneforty LLC · Dover, DEBuilt 1971 · S/N 28-7125315 N498HPSafe Flight Ops LLC · Venetia, PABuilt 1998 · S/N 3246121 N498JBBriggs James D · Maryville, TNBuilt 2005 · S/N 90498 N498LPN57kk LLC · Livingston, MTBuilt 2023 · S/N PX1520027 N498MALake Air Express LLC · Bettendorf, IABuilt 1998 · S/N 3246098 N498MMLadd Air LLC · Mt Holly, NCS/N 4636149 N498SPBmg Aviation Inc · Bloomington, INBuilt 1998 · S/N 172S8039

Back to AD 87-10-06 R1