Skip to content

Registered aircraft · 22,416

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.

N83833Campbell Anna Lu · Sheridan, ILS/N 28-8190234 N8383HAerni Brian S · Columbus, NEBuilt 1981 · S/N 28-8116221 N8383STrend Vector Aviation International Inc · Barrigada, GUS/N 28R8118044 N8383TLoyd Dayton A · Carbondale, ILBuilt 1981 · S/N 28-8116223 N8383VH&M Air LLC · Metamora, MIBuilt 1981 · S/N 28-8116224 N8383WMj Aero LLC · Mims, FLBuilt 1965 · S/N 28-2586 N8383ZFreeman Edward B · Killeen, TXBuilt 1981 · S/N 288190229 N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105 N8384EG & M Aircraft Inc · Wheat Ridge, COBuilt 1981 · S/N 28-8190236 N8384HTwin Tier Aviation Association Inc · Eldred, PABuilt 1981 · S/N 28-8190237 N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054 N8384SBuschmeier William A · Cincinnati, OHBuilt 1981 · S/N 28-8111065 N8384WWilt Jared C · Marysville, OHBuilt 1965 · S/N 28-2587 N8384YProgressive Flying Corp · North Salem, INBuilt 1981 · S/N 28-8111072 N8385QBlue Sky Harbors LLC · Crystal, MNBuilt 1981 · S/N 32-8106064 N8385SN8385s LLC · Lancaster, PABuilt 1981 · S/N 32-8106065 N8385WJohnson Robert J · Floral City, FLS/N 28-2588 N8386BSprj Aviation LLC · Tampa, FLBuilt 1981 · S/N 32R-8113068 N8386C86 Charlie LLC · Rochester, MNBuilt 1976 · S/N 28-7690134 N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067 N8387CRuday Dennis J DBA · Glendora, CABuilt 1976 · S/N 28-7625110 N8387RMiloud Chadd K · Fort Worth, TXBuilt 1966 · S/N 28-22264 N8387WHolt Zachary Ian · Bogalusa, LAS/N 28-2591 N83882Warrior 83882 LLC · Dover, DES/N 28-8116227 N8388RFloyd James · Gainesville, TXBuilt 1966 · S/N 28-22265 N8388WWatts Timothy S · Denver, NCBuilt 1965 · S/N 28-2592 N8388YInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116226 N83894Sale Reported · Grangeville, IDSale reportedBuilt 1981 · S/N 32-8124029 N8389AJacobus Larry E · Ipava, ILBuilt 1981 · S/N 28-8116228 N8389WStegemoller Ronald G · Washington, TXS/N 28-2594 N838CFCherokee Flyers Inc · Vero Beach, FLBuilt 2024 · S/N 2881838 N838DHGcbc LLC · Norman, OKBuilt 1979 · S/N 28-7916247 N838JHFitzmaurice Doyle · Sparta, WIS/N 28-7110009 N838MACca Aero Estate LLC · Missoula, MTS/N 28-7916019 N838PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843941 N8390CArserio Gregory J · Fairport, NYBuilt 1976 · S/N 28-7690130 N8390JPayne William A · Evansville, INS/N 32-8106083 N8390WLong Joseph · Mint Hill, NCBuilt 1965 · S/N 28-2595 N83914Upstate Aviators LLC · Spartanburg, SCBuilt 1981 · S/N 28-8290036 N8391QGambel E Anthony · Sewanee, TNBuilt 1981 · S/N 28-8116233 N8391SVip Medical Services LLC · Nixa, MOBuilt 1981 · S/N 28-8116234 N8391WNavara Cole J · Ulster Park, NYS/N 28-2596 N8391YSchafer Gary L · Greenwood, DEBuilt 1981 · S/N 28-8116235 N83922Archipelago Immobilien LLC · Jacksonville Beach, FLBuilt 1981 · S/N 32-8106069 N83924Moseley Barton S · Tomball, TXBuilt 1981 · S/N 32R-8113070 N8392TJ & L Flight Ventures LLC · Edgewater, MDBuilt 1981 · S/N 28R-8131140 N8392VSaunders Robert · Alpharetta, GABuilt 1981 · S/N 28R-8131141 N8393AMyhre Real Estate Management Inc · Rochester, NHBuilt 1981 · S/N 32R-8113071 N8393CAndersen Robin L · Cloverdale, CABuilt 1976 · S/N 28-7690131 N8393GRegistered aircraftBuilt 1981 · S/N 32R-8113072

Back to AD 87-08-08 R3