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.

N4585XFrost Aviation Services Inc · Las Cruces, NMBuilt 1975 · S/N 28-7690043 N4586ALewton John · Belgrade, MTBuilt 1956 · S/N 18-4895 N4586RGuasch Walter L · Reno, NVBuilt 1965 · S/N 28-21330 N4586XMccardle Michael L · Houston, TXBuilt 1975 · S/N 28R-7635086 N4586YRiggin Flight Service Inc · Madison, SDBuilt 1967 · S/N 25-4264 N4587AChasing Alaska Corp · Anchorage, AKBuilt 1957 · S/N 18-4896 N4587TStory'S Aviation Services LLC · Webster, FLBuilt 1972 · S/N 28-7225194 N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453 N4588JSierra Hotel Fliers LLC · Lexington Park, MDBuilt 1968 · S/N 28R-30459 N4588LLewis Robert J · Carthage, NCBuilt 1984 · S/N 70 N4588TLeavitt James W · North Ferrisburgh, VTBuilt 1972 · S/N 28-7205189 N4588XMaus Steven M · New Braunfels, TXBuilt 1975 · S/N 28-7615036 N4589JArthurs Nathanael L · Indiana, PABuilt 1968 · S/N 28R-30462 N4589XSek LLC · Concordia, MOS/N 28-7690045 N458AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843799 N458ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010058 N458BHEdwards Thomas M · New Tazewell, TNBuilt 2004 · S/N 82006 N458CDDiacont Charles R · Nazareth, PABuilt 2003 · S/N 18281231 N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850 N458DFontelieu James · Maplewood, NJBuilt 1979 · S/N AA5B1237 N458ESB R S Leasing Inc · Wilmington, DEBuilt 1998 · S/N 18280091 N458FLGentle Mike · Pendergrass, GABuilt 1971 · S/N 28-7125254 N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 28-43022 N458LBBeedy Lyle G · Derby, KSBuilt 2011 · S/N 20695 N458ME1st Avenue Ttc LLC · Los Angeles, CABuilt 1986 · S/N 739 N458MGFlywheel LLC · Charleston, WVBuilt 2005 · S/N T18208393 N458RVRussell Steven J · Wilmington, ILBuilt 2006 · S/N 71458 N458SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8323 N458UZStoik David E · Prunedale, CABuilt 1992 · S/N S-10-1-88010 N458WTls Aviation LLC · Smyrna, TNS/N 28-24511 N4590AEllis Darry Lynn · Wasilla, AKBuilt 1956 · S/N 18-4899 N4590FDavid Badaczewski · Gettysburg, PABuilt 1976 · S/N 28-7715052 N4590JEpic Aviation Inc · New Smyma Beach, FLBuilt 1968 · S/N 28R-30463 N4590ROzar Abdurrahman · Virginia Beach, VABuilt 1965 · S/N 28-21336 N4590TOdonald John C · Greenville, MIBuilt 1972 · S/N 28R-7235102 N4590WBfi Financial Alliances Limited LLC · Cave Creek, AZBuilt 1977 · S/N 13180 N4591HCampbell James R · Bennett, COBuilt 1979 · S/N 24-0855 N4591RJohnson Robert B · Wichita, KSBuilt 1965 · S/N 28-21337 N4591TCherokee 235 LLC · Sidney, NEFirst renewal noticeBuilt 1972 · S/N 28-7210015 N4591WRojas Franklyn N · Ocala, FLBuilt 1976 · S/N 13081 N4591XCoral Air LLC · Rock Rapids, IAS/N 28-7610045 N4593ABvm LLC · Stonington, CTBuilt 1956 · S/N 18-4903 N4593FSterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 28-7715054 N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330 N4593XClubs 2 LLC · Calabasas, CABuilt 1975 · S/N 28-7690046 N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278 N4594F181 Corporation · Charlotte, NCBuilt 1976 · S/N 28-7790048 N4594REkblad Carl Allyn · New Port Richey, FLBuilt 1966 · S/N 28-21341 N4594XAdventure Ventures LLC · Salem, CTBuilt 1975 · S/N 28R-7635088 N4595FSchroeder Herbert D · Plano, TXBuilt 1976 · S/N 28-7790049

Back to AD 87-10-06 R1