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.

N5722UPfeifer Eric P · Hill City, KSS/N 28-26524 N5723FOdyssia LLC · Corpus Christi, TXS/N 28-25024 N5723WWells Chad · Draper, UTBuilt 1963 · S/N 28-1281 N5724FKim Sungtae · Fort Worth, TXFirst renewal noticeBuilt 1968 · S/N 28-25025 N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827 N57252Mooney Flyers LLC · Crystal Lake, ILBuilt 1984 · S/N 24-1433 N57259Trantham Joey L · Panama City, FLBuilt 1984 · S/N 24-1435 N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799 N5725QBaughman Air Service Inc · Stockton, KSBuilt 1965 · S/N 721 N57262Steelesky Ltd · Maineville, OHBuilt 1975 · S/N 3239 N57266Department Of Public Safety · Baton Rouge, LABuilt 1974 · S/N 3208 N57267Devine Robert · Albuquerque, NMBuilt 1984 · S/N 24-1436 N5726QAllen Colin S · Leonardtown, MDBuilt 1965 · S/N 3065 N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928 N5727FJones Brian W · Portland, ORBuilt 1968 · S/N 28-25028 N57280Conklin Michael L · Grand Blanc, MIBuilt 1984 · S/N 24-1438 N57283Collins James L · Bradenton, FLBuilt 1984 · S/N 24-1439 N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802 N5728QKuss Luke A · Hutto, TXBuilt 1965 · S/N 3066 N5728UPagratis Periklis · Savannah, GABuilt 1970 · S/N 28-26545 N5728WGregor Ally W · Orlando, FLBuilt 1963 · S/N 28-1331 N57298Trent Daniel R Sr · Point Pleasant, WVBuilt 1973 · S/N 28R-7435074 N5729DLanzara Anne M · Salem, VABuilt 1956 · S/N 22-4427 N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803 N5729UFredericks Robert T · Burnsville, MNBuilt 1969 · S/N 28-26546 N572ABSchwab Craig A · Fort Walton Beach, FLS/N 572SF N572ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496194 N572FLLermo Corydon · Avon, NCBuilt 1971 · S/N 28-7125419 N572HCordrey Kenneth R · Delmar, DEBuilt 1976 · S/N 356 N572KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843900 N572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1973 · S/N 17261600 N572SPOld Friend Air LLC · Junction City, ORBuilt 2000 · S/N 172S8498 N572TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881872 N57304Koch Bruce R · Goodrich, MIBuilt 1973 · S/N 28-7425087 N57305C And D Company LLC · Lake Park, MNS/N 28R-7435077 N57309Olmedo Segundo L · Missouri City, TXBuilt 1973 · S/N 28-7425088 N5730FObrien Joseph · Saint Paul, MNBuilt 1968 · S/N 28-25032 N5730JLindley Field Flying School LLC · Greensboro, NCBuilt 1980 · S/N 17273828 N5730WKoprivnik Anton J · Painesville, OHS/N 28-1366 N57311Lelm Lyle K · Turtle Lake, NDBuilt 1973 · S/N 28-7415039 N5731ASimpson Christopher David · Reno, NVBuilt 2001 · S/N 3616 N5731DBamford Gregory R · Pace, FLBuilt 1956 · S/N 22-4431 N5731QSomers James K Trustee · Montgomery, TXBuilt 1965 · S/N 724 N5731VBig Bend Community College · Moses Lakes, WABuilt 1966 · S/N TD-652 N5731WLongview Aviation LLC · Newburgh, INBuilt 1963 · S/N 28-1380 N57320Resley Village Aero LLC · Carlton, TXBuilt 1973 · S/N 28-7425090 N57322N57322 LLC · Spout Spring, VABuilt 1973 · S/N 28-7425092 N57324Richards Jeremy · Franklin, TNBuilt 1973 · S/N 28R-7435080 N57325Baker Ken C · Tehachapi, CABuilt 1973 · S/N 28R-7435081 N5732DAerospace Center For Excellence Inc · Lakeland, FLBuilt 1956 · S/N 22-4432

Back to AD 87-10-06 R1