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.

N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259 N31961Duncanson Scott Alexander · Grand Blanc, MIBuilt 1978 · S/N 32R-7887017 N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488 N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260 N31977Wedekemper Donald E · Howell, MIBuilt 1978 · S/N 32R-7885148 N31981Elusive Aviation Inc · Pflugerville, TXBuilt 1978 · S/N 32R-7887018 N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604 N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605 N31994Montrose Douglas K · Glen Ellyn, ILS/N 28R-7803307 N31995One Zero Tango LLC · Chattanooga, TNBuilt 1978 · S/N 32R-7885149 N31996Seacoast Plane Partners LLC · Exeter, NHBuilt 1978 · S/N 32R-7885151 N31998Lance Group LLC · Moab, UTBuilt 1978 · S/N 32R-7887019 N319CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881505 N319EGVertx Fleet Holdings LLC · San Diego, CABuilt 2021 · S/N 28020021 N319FTPerez Guillermo T · Castaic, CABuilt 1982 · S/N 28-8216208 N319SFKruise Brian · Bonita, CABuilt 1978 · S/N 32R-7885140 N31BKBlackwell Derek G · Florence, SCBuilt 1977 · S/N 32R-7780545 N31JWMiller Scott A · Granbury, TXBuilt 1973 · S/N 32-7300047 N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236 N31NDSchloesser Raymond E · Poland, INS/N 32-654 N31PWClark David L · Washoe Valley, NVBuilt 1968 · S/N 32-40510 N31RKf Lift LLC · Snyder, TXBuilt 1978 · S/N 32R-7885150 N31REManley Brian C · Glen Allen, VABuilt 1966 · S/N 32-530 N31RFLegend48 LLC · Newton, NCS/N 32-7700023 N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080 N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314 N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208 N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179 N32003Gem Aviation Corp · Sugar Land, TXBuilt 1974 · S/N 28-7515043 N32004Priceless Pleasures LLC · Jordan, MNBuilt 1974 · S/N 28-7515044 N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014 N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126 N3200WBrickley Brian J · Manchester, MIBuilt 1964 · S/N 32-04 N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017 N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015 N32025Biafora Joseph R Jr · Panorama City, CABuilt 1974 · S/N 28-7510008 N32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048 N32037Conyers Jeffrey P · Sevierville, TNBuilt 1974 · S/N 32-7540009 N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052 N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053 N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018 N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016 N32056Steuer Christopher · Plumas Lake, CABuilt 1974 · S/N 28-7515056 N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021 N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059 N32067Legeros David · Brooklyn, NYS/N 28-7515060 N32068Christensen Gary L · Royal City, WABuilt 1974 · S/N 28-7515061 N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062 N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022 N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129

Back to AD 87-08-08 R3