Skip to content

Registered aircraft · 20,687

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N8077ESws Aviation Services Inc · Titusville, FLBuilt 1978 · S/N 17272133 N8077LAndrews Carson D · Hartsville, SCBuilt 1967 · S/N 17256277 N80781P D H S Aerial Photography Inc · Spicewood, TXBuilt 1976 · S/N 17266745 N80784Stamm David A · Lake Almanor, CAS/N 17266747 N80788Bell Aa Flying Club Inc · Mechanicsburg, PABuilt 1976 · S/N 17266748 N8078BShareair LLC · Columbiaville, MIS/N 29878 N8078LSale Reported · HawkestoneSale reportedBuilt 1967 · S/N 17256278 N80790Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266749 N80797Neitz Frank · Bethel, AKS/N 17266750 N80798Thomas Dean Properties LLC · O Fallon, MOBuilt 1976 · S/N 17266751 N8079LHurricane Joaquin LLC · Umatilla, FLS/N 17256279 N807CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12629 N807EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13181 N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730 N807PAAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9953 N807SPCawthon James B · Chelsea, ALBuilt 1999 · S/N 172S8111 N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752 N80803Bradley Charles S · East Bethel, MNS/N 17266754 N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755 N8080BNeton Inc · Bradenton, FLBuilt 1957 · S/N 29880 N8080XWard B J · Hewitt, NJBuilt 1961 · S/N 17248580 N80810White Hawk Aviation Inc · Brandy Station, VABuilt 1976 · S/N 17266757 N80816Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1976 · S/N 17266760 N8081LAerowood Aviation LLC · Monroe, NCBuilt 1967 · S/N 17256281 N8082EAviation Access LLC · Van Nuys, CABuilt 1978 · S/N 17272135 N8082LBurns Jeremiah W · Westerville, OHS/N 17256282 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 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 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 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 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 N8087LBawden Scott L · Saint George, UTS/N 17256287 N8087XMagers William L · Nampa, IDS/N 17248587 N80884Rein W Clark · Ottawa, KSBuilt 1976 · S/N 17266788 N8088LMarciano Raymond P · Cleveland, OHS/N 17256288

Back to AD 90-06-03 R1