Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N3515NClauson Jesse W · Agawam, MABuilt 1967 · S/N 680079 N3515XSayre Mikko · Madison, WIBuilt 1966 · S/N 670053 N35163Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17702239 N35165N35165 LLC · Starkville, MSBuilt 1975 · S/N 17702241 N3516XThompson Richard F · Boone, NCBuilt 1966 · S/N 670054 N3517NTronaas Chris E · Hamilton, MTBuilt 1967 · S/N 680080 N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045 N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252 N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253 N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255 N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256 N35193Mccormack Duncan M · Sunfield, MIS/N 17702257 N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260 N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261 N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220 N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918 N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263 N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046 N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267 N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268 N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047 N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270 N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271 N3521HCochran William T · Clermont, FLBuilt 1976 · S/N 22-1433 N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272 N35225Nguyen Ricky L · Honolulu, HIS/N 17702275 N3522EKilgore William B · Eureka, CAS/N 17271572 N3522NRegistration Pending · Mandeville, LARegistration pendingBuilt 1967 · S/N 680082 N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661 N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048 N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283 N3523HGrossman Rebecca L G · Slate Hill, NYBuilt 1976 · S/N 22-1434 N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278 N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286 N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288 N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289 N3524NRickard Donald S · Florence, ALBuilt 1967 · S/N 680083 N3524XKendrick Brian S · Kerrville, TXBuilt 1966 · S/N 670061 N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293 N3525HDavis Rodney M · Savannah, GABuilt 1976 · S/N 22-1435 N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296 N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297 N3526HLyons Donald F · Cheverly, MDFirst renewal noticeBuilt 1980 · S/N 24-1035 N3526NDace Joshua R · Rochester Hills, MIBuilt 1967 · S/N 680084 N3526XSchiebel Philip A · Walla Walla, WAS/N 670063 N35273Weltmer Aaron Reece · Rocklin, CABuilt 1975 · S/N 17702303 N35278Sparks Tommy R · Palestine, ILBuilt 1975 · S/N 17702305 N3527HFlight Meo LLC · Daytona Beach, FLBuilt 1976 · S/N 20-1222 N3527NMooney 3527 LLC · North Las Vegas, NVS/N 680085 N35281Freebird Wings LLC · Creswell, ORBuilt 1975 · S/N 17702306

Back to AD 80-25-07 R1