Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N4320YLochner Thomas H Trustee · Saratoga Springs, NYS/N 28-8416014 N43214Bellard Cedric · Valrico, FLBuilt 1974 · S/N 28-7415446 N43215Gremel Tyler · Ellensburg, WABuilt 1974 · S/N 28R-7435254 N43218On Final Aviation LLC · Brookland, ARBuilt 1974 · S/N 28-7425345 N43219Stading William T · Hackensack, MNBuilt 1974 · S/N 28-7415447 N4321FVales Louis · Monroe, NYBuilt 1976 · S/N 28R-7635455 N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695 N4321TSale Reported · Signal Hill, CASale reportedBuilt 1971 · S/N 28R-7235007 N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181 N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346 N4322FAdk Xc Flyers LLC · Scotia, NYBuilt 1976 · S/N 28R-7635456 N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696 N4322KCalm Skies LLC · Austin, TXS/N 32-8324013 N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015 N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450 N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451 N43237Duesler Donald W · Beaumont, TXBuilt 1952 · S/N 28-7415452 N4323FMisty Aviation LLC · Wilmington, DEBuilt 1976 · S/N 32R-7680507 N4323TBreitenstine Matthew · Dallas, TXBuilt 1971 · S/N 28R-7235008 N4323XRegistered aircraftBuilt 1975 · S/N 28-7690016 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 N4324JStaple K Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 28-22699 N43257P23 LLC · Edmond, OKBuilt 1974 · S/N 28-7405183 N43259Hoklov Vladimir · Castle Pines, COS/N 28R-7435258 N4325FIreland David · Eatonville, WABuilt 1976 · S/N 28-7715017 N4325JJpsc LLC · College Station, TXBuilt 1967 · S/N 28-22700 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 N43268Inter Global Aviation LLC · New Fairfield, CTBuilt 1974 · S/N 28-7415461 N4326FNationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 28-7715018 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 N43276Wilson Steven D Trustee · Mount Pleasant, IABuilt 1974 · S/N 32-7440120 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 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 N4328BRepeta Wayne Robert · Bedford, NHBuilt 1983 · S/N 32R-8429003 N4328JWeldon Thomas · Marysville, OHBuilt 1967 · S/N 28-22703 N4328NTalker Albert · Stroudsburg, PABuilt 1983 · S/N 28-8416020 N4328TWhite Mickey S · Hyrum, UTBuilt 1970 · S/N 28-26927 N43291Etheredge Mark · Pell City, ALBuilt 1974 · S/N 28-7415448 N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021

Back to AD 87-08-08 R3