Skip to content

Registered aircraft · 72,007

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.

N3523DQuick Gas Aviation LLC · Thomasville, GABuilt 1979 · S/N 31-7952112 N3523MMichigan Seaplane LLC · White Lake, MIBuilt 1947 · S/N 12-2369 N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277 N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278 N3523WRamunni Andrew R · Medina, OHBuilt 1966 · S/N 32-408 N3523YL A B Flying Service Inc · Renton, WAS/N 31-7952115 N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286 N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288 N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031 N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289 N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030 N3524FRegistered aircraftBuilt 2001 · S/N 18280975 N3524LFlight Training Aircraft LLC · Wilmington, DEBuilt 2001 · S/N 172S8809 N3524NRickard Donald S · Florence, ALBuilt 1967 · S/N 680083 N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279 N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462 N3524WDiaz Albert · Ocean Springs, MSS/N 32-409 N3524XKendrick Brian S · Kerrville, TXBuilt 1966 · S/N 670061 N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427 N35253Liu Kaiyu · Metairie, LABuilt 2001 · S/N 172S8831 N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293 N3525URandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8826 N3525WDavis Micihael K · Madison, GABuilt 1966 · S/N 32-411 N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428 N35261Walrath Aviation LLC · Tacoma, WABuilt 2001 · S/N T18208013 N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296 N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297 N35269Marlin Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 31-7952136 N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606 N3526NDace Joshua R · Rochester Hills, MIBuilt 1967 · S/N 680084 N3526WN3526w Holding LLC · Harlem, GABuilt 1966 · S/N 32-412 N3526XSchiebel Philip A · Walla Walla, WAS/N 670063 N3526ZSwett John P · Zebulon, NCBuilt 1960 · S/N 22-7429 N3527Link James L · Raleigh, NCBuilt 1971 · S/N ELC-1 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 N3527XSzmagala Taras G Jr · Bentleyville, OHBuilt 1975 · S/N 32-7540163 N35281Freebird Wings LLC · Creswell, ORBuilt 1975 · S/N 17702306 N35284Flying Redbirds LLC · Wentzville, MOBuilt 1975 · S/N 17702307 N35287White James E · Eminence, KYBuilt 1975 · S/N 17702308 N35288Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-605 N3528DBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 18280960 N3528HBlack Kevin John · Edgewater, FLBuilt 1976 · S/N 20-1223 N3528PSalerno Joseph C Jr · Gettysburg, PABuilt 1955 · S/N 22-3283 N352964 Point Transportation LLC · Excelsior Springs, MOS/N 17702312 N3529AMajestic Enterprises Ltd · Wilmington, DEBuilt 1979 · S/N 31-7952152 N3529KEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 28-23544 N3529WMission Flight · El Monte, CABuilt 1979 · S/N 31-7952159

Back to AD 87-10-06 R1