Skip to content

Registered aircraft · 72,000

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.

N125MGHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496152 N125MSRegistered aircraftS/N 2022 N125PJSpencer Aviation Services LLC · Sanger, TXBuilt 2011 · S/N 570 N125RWallace Flying Service Inc · Wallace, NEBuilt 1976 · S/N 18-7709017 N125RMGurtman Samuel · Deerfield, ILBuilt 1978 · S/N AA5B0698 N125RSAlexander William F · Chapmansboro, TNBuilt 1991 · S/N 657-91 N125SVan Fleet Susan Jo · Central, SCBuilt 1973 · S/N 17262802 N125SEDyer John F · Spring, TXBuilt 1969 · S/N 61-0027 N125SLSlingshot Aviation LLC · Chandler, AZBuilt 2003 · S/N 18281253 N125VSMcfarland Joel E · Pittsford, NYBuilt 1979 · S/N 28-7990399 N125WB90er LLC · Wilmington, DEBuilt 2008 · S/N 505-2008 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1963 · S/N 27-2366 N12600Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262103 N12602Darke County Aircraft Rental Inc · New Madison, OHBuilt 1973 · S/N 17262104 N12604Cendejas Agustin · Chino, CABuilt 1973 · S/N 17262106 N1260JHillhouse Mark S · Angie, LABuilt 1975 · S/N 260 N1260TRed Rock Flying School LLC · Mesa, AZBuilt 1972 · S/N 28-7225441 N1260USigma Aviation LLC · Dover, DEBuilt 1976 · S/N 17266955 N1260XCross Paul D · Cowan, TNBuilt 1963 · S/N 133 N12613Nashville Flight School LLC · Nashville, TNBuilt 1973 · S/N 17262113 N12617Sheatz Brian J · Houston, TXS/N 17262116 N1261BClark Robert J · Brookshire, TXS/N 1261 N1261TObrien Timothy D · Alplaus, NYBuilt 1972 · S/N 28-7205273 N1261UVlftec Inc · Ames, IABuilt 1976 · S/N 17266956 N12622Allen Gerald J · Florence, MTBuilt 1973 · S/N 17262120 N12623Registration Pending · La Jolla, CARegistration pendingBuilt 1973 · S/N 17262121 N12624Leer Darryl K · Kaunakakai, HIBuilt 1973 · S/N 17262122 N12625Tnt Airworks LLC · Hibbing, MNBuilt 1973 · S/N 17262123 N1262JMendez Leo Jr · Corpus Christi, TXS/N 262 N1262UA D S Aircraft Management Inc · Plymouth, MABuilt 1976 · S/N 17266957 N1262XHawley Christopher M · Chandler, AZBuilt 1963 · S/N 135 N12630Skywarrior Flight Training · Pensacola, FLBuilt 1973 · S/N 17262126 N12631Hurtuk Joseph M · Delray Beach, FLBuilt 1974 · S/N 17262127 N12632Walraven Michael G · Horton, MIBuilt 1973 · S/N 17262128 N12635Schnell Jonathan E · Newtown, PABuilt 1973 · S/N 17262130 N12641Wanda Collins Professional Pilot Services LLC · Madisonville, TXS/N 17262136 N12647Mcmahon Dwayne A · Leavenworth, WAS/N 17262142 N12648Aircraft Trade Group LLC · Scandia, MNBuilt 1973 · S/N 17262143 N12649Miller Jacqueline E · Corning, NYBuilt 1973 · S/N 17262144 N1264APierskalla Nicolas B · Wasilla, AKBuilt 1951 · S/N 18-1060 N1264THolloway Andrew F · Woodville, TXBuilt 1972 · S/N 28-7225457 N1264USky Creation Inc · Torrance, CABuilt 1976 · S/N 17266959 N1264XAnderson Kyle S · Portland, ORBuilt 1963 · S/N 137 N12650Villegas Guillermo · Scottsdale, AZS/N 17262145 N12651Kelley Aircraft LLC · Weyers Cave, VABuilt 1973 · S/N 17262146 N12653Bryant Jeffrey · Red Bluff, CABuilt 1973 · S/N 17262148 N12655Ker Holdings LLC · Henderson, NVBuilt 1973 · S/N 17262150 N12657Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 17262152 N12661Jb Aviation Flight School Inc · Wonder Lake, ILBuilt 1973 · S/N 17262156

Back to AD 87-10-06 R1