Skip to content

Registered aircraft · 72,001

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.

N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345 N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208 N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193 N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194 N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195 N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176 N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004 N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210 N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196 N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197 N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095 N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022 N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213 N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214 N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200 N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060 N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007 N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096 N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226 N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203 N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079 N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104 N1597JLs Aviation LLC · Searcy, ARS/N 28-24008 N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218 N1598BTimerider Technologies Inc · Bishop, CABuilt 1982 · S/N 18268108 N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009 N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098 N15994Self Thomas C · Madisonville, TNS/N 28-7325222 N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210 N15999Emmert Jason L · Douglas, WYBuilt 1973 · S/N 28-7310081 N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845 N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245 N159ARRobertson Duncan · ForfarNon-citizen corporation, flight hours not reportedBuilt 2007 · S/N 47013T N159AWLutz Robert J · Mount Victory, OHBuilt 1978 · S/N 18-7809035 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159DBJohnson Justin T · Wasilla, AKBuilt 2019 · S/N 001 N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005 N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128 N159DSSmart Charles R · Verden, OKBuilt 1978 · S/N 70384 N159DWWilcoxon Duane E · Arlington, WAS/N PITTS 01 DW N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211 N159JDDorrance John Charles Jr · Randle, WABuilt 1987 · S/N 4042C N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751 N159LBBender Lyle D · Lincoln, NEBuilt 2009 · S/N 40403 N159MHPw Air LLC · Rockingham, VABuilt 2001 · S/N 1135 N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031 N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038 N159RPHeadings Norman D · Walnut, ILBuilt 1997 · S/N 0342 N159RRRatliff Randall L · Glencoe, OKBuilt 2018 · S/N 41712 N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817

Back to AD 87-10-06 R1