Skip to content

Registered aircraft · 8,138

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N262R262r LLC · Richland, WABuilt 1966 · S/N 28-21931 N262SASundance Airport LLC · Yukon, OKBuilt 1967 · S/N 28-4047 N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258 N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063 N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079 N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067 N2661TSix One Tango LLC · Pismo Beach, CABuilt 1971 · S/N 28-7205069 N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070 N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092 N2669TCity Of Westfield · Westfield, MAS/N 28-7225082 N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075 N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084 N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074 N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077 N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078 N267AGSimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 28-7425114 N267DPCarrasco Mario G · Glendora, CABuilt 1967 · S/N 28-22673 N2680TAviyon Aviation LLC · Orlando, FLBuilt 1971 · S/N 28-7225085 N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086 N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082 N2684TGallaher Matthew · Anchorage, AKBuilt 1971 · S/N 28-7225087 N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083 N2687THolley Ronald E · Hastings, MIBuilt 1971 · S/N 28-7205093 N2688BScott Fred · Greencastle, INBuilt 1968 · S/N 28-5065 N2691TSilkgate Aviation LLC · Yorba Linda, CABuilt 1971 · S/N 28-7205065 N2692TWingsleasing LLC · Wichita, KSBuilt 1971 · S/N 28-7205072 N2694TStubby Wings LLC · Eden Prairie, MNBuilt 1971 · S/N 28-7205085 N2695TJean-Baptiste Joseph C Sr · Brockton, MABuilt 1971 · S/N 28-7225089 N2696TRsp Aero LLC · Griffin, GABuilt 1971 · S/N 28-7205087 N26KAOliver Brian · North Attleboro, MABuilt 1964 · S/N 28-20380 N2709UGeist Paul J · Landenberg, PABuilt 1974 · S/N 28-7425221 N270SASundance Airport Fbo LLC · Yukon, OKBuilt 1966 · S/N 28-21576 N2711TLucero Nicholas T · North Hollywood, CABuilt 1966 · S/N 28-21917 N2723BPiston Aviation LLC · Saint Charles, MOBuilt 1969 · S/N 28-25852 N272FDFly Dynasty Corp · Ocala, FLBuilt 1968 · S/N 28-24693 N272KSOlson Richard · Eau Claire, WIBuilt 1967 · S/N 28-23936 N274TEBas Part Sales LLC · Greeley, COS/N 28-1545 N275JKKrol Jeffrey P · Somers, CTBuilt 1969 · S/N 28-26151 N2760QCastle Rock LLC · Cascade, MTS/N 28-7725205 N277MMSolan Richard J · Canaan, CTS/N 28-7325295 N277SAFox Matthew C · Athlone WestheathNon-citizen corporation, flight hours not reportedS/N 28-21661 N27KKButler Robert Wynne Jr · Boyce, LABuilt 1962 · S/N 28-792 N2803TBarron David L · Sun City, AZBuilt 1972 · S/N 28-7225241 N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223 N2807TSale Reported · Broxton, GASale reported, canceledBuilt 1972 · S/N 28-7205224 N280TCNobles Gary D · Fairview, TXS/N 28-21227 N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237 N2818TLb33 LLC · Helena, MTBuilt 1972 · S/N 28-7225239 N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227 N2829TSeal Dennis J · Dallas, TXS/N 28-7225243

Back to AD 96-10-01 R1