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.

N4322FAdk Xc Flyers LLC · Scotia, NYBuilt 1976 · S/N 28R-7635456 N4322GMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N 032 N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696 N4322RKing Air Charter LLC · Zanesville, OHBuilt 1978 · S/N R18200590 N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524 N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015 N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636 N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450 N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451 N4323FMisty Aviation LLC · Wilmington, DEBuilt 1976 · S/N 32R-7680507 N4323HRucker Edward A · Longview, TXS/N 24-0704 N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223 N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076 N4323TBreitenstine Matthew · Dallas, TXBuilt 1971 · S/N 28R-7235008 N4323XRegistered aircraftBuilt 1975 · S/N 28-7690016 N4323ZDubious Adventures LLC · Big Lake, AKS/N 18-8638 N43240O'Quinn Kayla M · Jesup, GABuilt 1974 · S/N 28-7405182 N43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAS/N 28-7425349 N43243Gomez Herbert · Holdenville, OKBuilt 1974 · S/N 28-7415453 N43247Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 28-7415456 N4324HTrott James E · Cathlamet, WAS/N 185569 N4324JStaple K Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 28-22699 N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077 N4324ZBretts Spray Service Inc · Onida, SDFirst renewal noticeBuilt 1968 · S/N 18-8639 N43257P23 LLC · Edmond, OKBuilt 1974 · S/N 28-7405183 N4325BWattum Joel W · Wasilla, AKBuilt 1955 · S/N 26669 N4325FIreland David · Eatonville, WABuilt 1976 · S/N 28-7715017 N4325JJpsc LLC · College Station, TXBuilt 1967 · S/N 28-22700 N4325QBeier Mark E · Sylvania, GABuilt 1971 · S/N 17260225 N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078 N4325TBledsoe Randell W · Springtown, TXBuilt 1971 · S/N 28-7205141 N4325UMetro Aircraft Co · Bloomington, MNBuilt 1983 · S/N 28-8416016 N4325VArcher Assoc LLC · Ashburn, VABuilt 1983 · S/N 28-8416017 N43263Healey Terrance P · Redding, CABuilt 2005 · S/N 5014 N43266Sky High Helicopters LLC · Camarillo, CABuilt 1990 · S/N 1268 N43268Inter Global Aviation LLC · New Fairfield, CTBuilt 1974 · S/N 28-7415461 N4326JHayes Barrett W · Siler City, NCBuilt 1967 · S/N 28-22701 N4326LN4326l LLC · Senoia, GABuilt 1983 · S/N 28-8490015 N4326NLikakis John M · Bennington, VTBuilt 1983 · S/N 28-8490017 N4326QStar Fleet Aviation LLC · Bisbee, AZBuilt 1971 · S/N 17260226 N4326ZSuchland Simon K · North Pole, AKBuilt 1968 · S/N 18-8643 N43276Wilson Steven D Trustee · Mount Pleasant, IABuilt 1974 · S/N 32-7440120 N4327ACasten Scot R · Vernonia, ORBuilt 1956 · S/N 22-3682 N4327JDowling Investments LLC · Gillette, WYBuilt 1983 · S/N 32-8406001 N4327MDestiny: Success LLC · San Luis Obispo, CABuilt 1983 · S/N 32R-8413001 N4327PKing Air Inc · Naknek, AKS/N 32-8406002 N4327QFackler Aviation Services LLC · Clearwater, FLBuilt 1971 · S/N 17260227 N4327WDevline Air LLC · Little Rock, ARBuilt 1983 · S/N 32R-8429002 N43287Carlucci Peter M · Pittstown, NJBuilt 1974 · S/N 28-7415420 N43289Prickett Terry L · Albertville, ALS/N 28-7415421

Back to AD 87-10-06 R1