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.

N5115CSeipp Stephen C · Laurel, DES/N 3257209 N5115SBridgeport Flying Club LLC · Bridgeport, CABuilt 1971 · S/N 28R-7135149 N5116LLits LLC · Bowling Green, KYBuilt 1967 · S/N 28-4399 N5116SWizco Company LLC · Norfolk, NEBuilt 1971 · S/N 28-7105169 N5117LEmery Jonathan D · Payson, AZBuilt 1967 · S/N 28-4400 N5117WJorgensen-Tjorneho Erik R · Conroe, TXBuilt 1961 · S/N 28-142 N5119WLe Thanh Q · Santa Ana, CABuilt 1961 · S/N 28-144 N511AGIc Johnson LLC · Belton, SCBuilt 1967 · S/N 32-496 N511BSMurphy David G · Apalachin, NYBuilt 1978 · S/N 28-7990057 N511DXPiper Aircraft Inc · Vero Beach, FLS/N 28010111 N511JRN511jr LLC · Taylor, MOBuilt 1976 · S/N 32R-7680476 N511MARrs Company Inc · Midville, GABuilt 1998 · S/N 3246111 N511RFOlson Dean W · Shelbyville, KYBuilt 1971 · S/N 28-7105167 N5120GGoering Vincent R · Hephzibah, GABuilt 1968 · S/N 28-4937 N5120LClifford Scott P · Wallkill, NYBuilt 1967 · S/N 28-4403 N5120SIntentus Aviation LLC · Sunset, TXBuilt 1971 · S/N 28-7105171 N5121GWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 28-5005 N5121SSandmann Ross · Plano, TXBuilt 1971 · S/N 28-7105175 N5121WCarroll Thomas F · Independence, MOBuilt 1961 · S/N 28-146 N5122LJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1967 · S/N 28-4405 N5122SKudla Frank R · Bean Station, TNBuilt 1971 · S/N 28-7105172 N5122WSale Reported · Cape Elizabeth, MESale reportedBuilt 1961 · S/N 28-148 N5124LCrisp Phil · Greencastle, PABuilt 1967 · S/N 28-4407 N5124SCalvert David · Livermore, CABuilt 1971 · S/N 28R-7135154 N5125SSlade Clark K · Pinckney, MIBuilt 1971 · S/N 28R-7135157 N5125WElyon Holdings LLC · Gulf Shores, ALBuilt 1961 · S/N 28-151 N5126LMccoy Jiro · Fort Walton Beach, FLBuilt 1967 · S/N 28-4409 N5126SRyan Kevin M · Xenia, OHBuilt 1971 · S/N 28-7105173 N5127GKurtz Joseph A · Hamilton, GAS/N 28-24675 N5127SWeston Thomas J · Stratford, NJBuilt 1971 · S/N 28-7125457 N5128GSale Reported · Gainesville, FLSale reported, pending cancellationBuilt 1968 · S/N 28-24669 N5128LSquawk 2017 LLC · Flowery Branch, GABuilt 1967 · S/N 28-4411 N5128SDonegan Martin A O · Bethlehem, PABuilt 1971 · S/N 28-7125512 N5129SSplendid Aviation Inc · Corpus Christi, TXBuilt 1971 · S/N 28-7125600 N5129WStanek Kenneth W Jr · Russellville, ARBuilt 1961 · S/N 28-156 N512AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020043 N512CSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 3257396 N512CSR Scott Hoffman/Silverado Transportation LLC · Kalispell, MTBuilt 1977 · S/N 28R-7837048 N512DXPiper Aircraft Inc · Vero Beach, FLS/N 28010112 N512EZCmtg Real Estate Enterprises Inc · Lakeland, FLBuilt 2005 · S/N 3257373 N512FLReiley Allen Ted · Lavernia, TXBuilt 1971 · S/N 28-7125336 N512MACurrie George H III · Fleming Island, FLBuilt 1977 · S/N 28-7716224 N512MSTiralongo Sebastiano · Weston, FLBuilt 1992 · S/N 2841349 N512PTHigh Performance Aircraft LLC · El Cajon, CABuilt 1973 · S/N 28-7305101 N512TFN408dm LLC · Rye, NYBuilt 2022 · S/N 2881593 N512USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3213007 N5130LSalisbury Gershom · Prescott, AZBuilt 1967 · S/N 28-4413 N5130SHillis Grady Leroy · Lakeside, AZBuilt 1971 · S/N 28-7110021 N5130WMccutcheon Ernest Thomas · Ninety Six, SCBuilt 1961 · S/N 28-157 N5131LSkipper Up LLC · Herron, MIS/N 28-4414

Back to AD 87-08-08 R3