Skip to content

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.

N555QFColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1992 · S/N 2890173 N555QRCarry On Leasing Inc · Wilmington, DEBuilt 2003 · S/N 10140 N555RLBorek Thomas J · Homestead, FLBuilt 1994 · S/N 5307 N555RMCulwell Lewis D · Helena, MTBuilt 1988 · S/N 397 N555RSR&M Aviation LLC · Austell, GABuilt 1963 · S/N M-412 N555RUHands Holding · Newark, DEBuilt 1981 · S/N 32R-8129114 N555SLHuffman Jacob M III · Burleson, TXBuilt 1973 · S/N 17262755 N555SMWalla Walla University · College Place, WABuilt 1973 · S/N 17261805 N555SSSkylink Group LLC · York, PABuilt 1976 · S/N 14045 N555TPNugget Investments LLC · Strongsville, OHBuilt 1979 · S/N 32R-8029041 N555TWMccabe Robert J Trustee · Cherry Hill, NJBuilt 1973 · S/N 28-7305578 N555UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3550 N555UMBoretide Aviation LLC · Anchorage, AKBuilt 1971 · S/N 28-7105078 N555UPAtlantic Coast Helicopter Ltd · Ronkonkoma, NYBuilt 1998 · S/N 2792 N555UWMcdaniel John D Jr · Leesburg, GABuilt 1978 · S/N 32R-7887117 N555VCBassetti Cody J · Paso Robles, CABuilt 1969 · S/N 28-26049 N555VKChet W Fortney LLC · Helena, MTBuilt 1979 · S/N R18201207 N555VSMcgregor Daniel A · Denali Park, AKBuilt 1971 · S/N 31-791 N555WRCentral Ridge Consulting Inc · Beverly Hills, FLBuilt 1994 · S/N 20187 N555WUChapman Leland R · Carencro, LABuilt 2000 · S/N 23897 N555XCTriple Five Air LLC · Redwood City, CABuilt 2004 · S/N S 52 N555XPTri Air Inc · Aulander, NCBuilt 1999 · S/N 2032 N555YFRathje Norm · Wills Point, TXBuilt 2004 · S/N 70049 N555ZFuller Michael B · Winter Garden, FLBuilt 1952 · S/N 18-913 N555ZHWurth Gary P · Rochester, NYS/N 17268439 N555ZMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N CC19-0011 N555ZWGrenda Adam J · King Salmon, AKBuilt 2010 · S/N HSC-2010-01 N55605Parrish Don A · Plains, TXBuilt 1973 · S/N 28-7325440 N55606Falcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325441 N55608Thunderbird Aviation LLC · Shawnee, OKS/N 28-7305423 N5560FVandyke Jason M · Gettysburg, PABuilt 1968 · S/N 28-24900 N5560JSanilac Air LLC · Applegate, MIS/N 32-1025 N5560MA-1 Auto Reyclers · Columbia, MOBuilt 1967 · S/N 097 N55610Luxury Aviation LLC · Butler, PABuilt 1973 · S/N 28R-7335258 N55613Holmquist Hugh R · Burwell, NEBuilt 1973 · S/N 28-7310151 N55617Critchett Reggie D · Sterling Heights, MIBuilt 1973 · S/N 28-7325431 N55618Keller Paul D · Burlington, CTBuilt 1973 · S/N 28-7325443 N5561QRoberson Richard J Jr · Panama City, FLBuilt 1965 · S/N 2969 N55621Wood Steve · Fresno, CABuilt 1973 · S/N 28-7325446 N55622Detor Properties Inc · Rochester, NYBuilt 1973 · S/N 28-7305426 N55623Vector Aviation Services LLC · Groesbeck, TXBuilt 1973 · S/N 28-7305427 N55628Ag Air Squadron Two LLC · Saint Joseph, ILBuilt 1973 · S/N 28R-7335261 N55629Mccarthy Robert · Farmers Branch, TXS/N 32-7340128 N5562FTom Brian A · Santa Clarita, CABuilt 1968 · S/N 28-24902 N5562UWilkosz Robert · Tampa, FLBuilt 1969 · S/N 28-26288 N5563MJudkovitz Shmuel · Brooklyn, NYBuilt 1967 · S/N 100 N5563PVahey James T III · Loxahatchee, FLBuilt 1958 · S/N 24-627 N5563QFishero John D · Spring, TXBuilt 1965 · S/N 2970 N5563UBlair James S · Beltsville, MDBuilt 1970 · S/N 28-26882 N55640Adams Charles G III · Tawas City, MIBuilt 1973 · S/N 28-7305430

Back to AD 87-10-06 R1