Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N80810White Hawk Aviation Inc · Brandy Station, VABuilt 1976 · S/N 17266757 N80816Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1976 · S/N 17266760 N8081ACorn Michael Lee · Wilmington, NCBuilt 1952 · S/N 20933 N8081EFlying Horseman Ranch LLC · Stuart, VABuilt 1974 · S/N 18502329 N8081LAerowood Aviation LLC · Monroe, NCBuilt 1967 · S/N 17256281 N8081TSproul Andrew W · Isabella, OKBuilt 1960 · S/N 17556781 N8081VStorm Flying Service LLC · David City, NEBuilt 1968 · S/N 188-0331 N8081XHibdon Robert R · Jefferson City, MOBuilt 1967 · S/N 18258166 N8082EAviation Access LLC · Van Nuys, CABuilt 1978 · S/N 17272135 N8082LBurns Jeremiah W · Westerville, OHS/N 17256282 N8082MKeenan Thomas E Jr · Smyrna, DES/N 15072542 N8082TStrahm Jennifer · Edgerton, KSBuilt 1960 · S/N 17556782 N8082XNewman Joseph N · Springfield, MIBuilt 1961 · S/N 17248582 N80830Mahnattan Flying Tigers Inc · Bozeman, MTBuilt 1976 · S/N 17266764 N80837Lucky Richard E · Skipperville, ALBuilt 1976 · S/N 17266767 N8083SKoenig William J · Benedict, MDS/N 15061683 N80841Sparta 140 Club Inc · Grand Rapids, MIBuilt 1976 · S/N 17266769 N80842Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266770 N80847Evergreen Flying Club Inc · Medina, WABuilt 1976 · S/N 17266771 N8084ARegistration Pending · Madison, NHRegistration pendingBuilt 1952 · S/N 20936 N8084BN8084b LLC · Fort Worth, TXBuilt 1975 · S/N 177RG0705 N8084FAustin Michael S · Utica, KYS/N 15064184 N8084SHunter Robert M · Rawlins, WYS/N 15061684 N8084TKnight Doyle D · Loon Lake, WABuilt 1960 · S/N 17556784 N8084XSnyder Paul G · Lincoln, NEBuilt 1961 · S/N 17248584 N80855Bowe Joseph E DBA · Chippewa Falls, WIBuilt 1976 · S/N 17266774 N8085BHowell Rebecca Elizabeth · Elgin, TXBuilt 1957 · S/N 29885 N8085EMcdonald Douglas A · Falls Church, VAS/N 17272137 N8085LDowns Warren · Dillingham, AKBuilt 1967 · S/N 17256285 N8085SSchulz Michael L · Norfolk, NEBuilt 1965 · S/N 15061685 N80864Kessler Garry A · Lansing, WVBuilt 1976 · S/N 17266778 N80865Green Rick A · Hudson, IABuilt 1976 · S/N 17266779 N80866Preston Richard K Trustee · Albuquerque, NMBuilt 1976 · S/N 17266780 N80868Paradis Paul A · Bar Harbor, MEBuilt 1976 · S/N 17266781 N8086ANievin Garrett P · Ashburn, VABuilt 1952 · S/N 20938 N8086TRains David O · El Paso, TXBuilt 1960 · S/N 17556786 N8086VSchmitt Rudy · Brookshire, TXS/N 188-0336 N8086XPaumen Kurt J · Ramsey, MNBuilt 1961 · S/N 17248586 N80870Robben William J · Pampa, TXBuilt 1976 · S/N 17266782 N80871Monnin Aviation LLC · Amherst, NYBuilt 1976 · S/N 17266783 N80872Yakima 872 Flying Club · Yakima, WABuilt 1976 · S/N 17266784 N80874Jls Aviation LLC · Fredericksburg, VABuilt 1976 · S/N 17266786 N8087ARichards Vincent C · Deland, FLBuilt 1952 · S/N 20939 N8087FWarbington Michael L · Enid, OKS/N 15064187 N8087LBawden Scott L · Saint George, UTS/N 17256287 N8087SBridges Jeffrey · Allen, TXBuilt 1965 · S/N 15061687 N8087XMagers William L · Nampa, IDS/N 17248587 N80884Rein W Clark · Ottawa, KSBuilt 1976 · S/N 17266788 N8088LMarciano Raymond P · Cleveland, OHS/N 17256288 N8088SRutherford Thom J · Birchwood, WIBuilt 1965 · S/N 15061688

Back to AD 87-20-03 R2