Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N6746NOlive City Flying Club Inc · Corning, CABuilt 1968 · S/N 680191 N6747HAurora Skyhawks · Portland, ORS/N 17265564 N6747NBolt Almos L Jr · Montgomery, TXBuilt 1968 · S/N 680061 N6747UDevuyst Richard C · Pampa, TXBuilt 1963 · S/N 2469 N67483Livingston Aviation Inc · Waterloo, IABuilt 1978 · S/N 15281858 N67487Sls Air LLC · Lake Worth, FLBuilt 1978 · S/N 15281861 N6748HN6748h LLC · Palm Beach Gardens, FLBuilt 1975 · S/N 17265565 N6748NMcneil Scott · Phoenix, AZS/N 680192 N67490Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281863 N67495Cc Aviation Inc · Tracy, CABuilt 1978 · S/N 15281866 N6749NFosburgh Kevin J · Las Cruces, NMBuilt 1968 · S/N 680062 N67506Milne Sales And Services LLC · Lake Geneva, WIS/N 15281875 N67507Wright Aero Inc · Saint Cloud, MNBuilt 1978 · S/N 15281876 N67508Utah State University · Logan, UTBuilt 1978 · S/N 15281877 N6750HPickett Michael R · Gig Harbor, WABuilt 1975 · S/N 17265566 N6750UFischer James C · Falls City, NEBuilt 1963 · S/N 2472 N67512Indiana State University · Terre Haute, INBuilt 1978 · S/N 15281880 N6751NParr Matthew R · Wellsville, PABuilt 1968 · S/N 680065 N6751VManley William T Jr · Lakeside, TXS/N 700051 N67527H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1978 · S/N 15281892 N6752ULucarelli Michael · Surprise, AZBuilt 1963 · S/N 2474 N67535Afana Lawrence L · Laughlin, NVBuilt 1978 · S/N 15281897 N6753NHarmon Benjamin P · Olive Branch, MSBuilt 1968 · S/N 680067 N6753VDegraffenreid Donald R · Fort Mohave, AZBuilt 1970 · S/N 700052 N67541Lane Community College · Eugene, ORBuilt 1978 · S/N 15281902 N67549Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281907 N6754NCasady David E · Harriman, TNBuilt 1968 · S/N 680068 N6754VTharp Kenneth Lynn · Apple Valley, CABuilt 1970 · S/N 700054 N67557Sunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N 15281910 N67563Canarr Nellie N E · Anchorage, AKS/N 15281913 N67567Pinger Kevin R · Palo Alto, CAS/N 15281916 N6756UBergland John E · Santa Monica, CABuilt 1963 · S/N 2478 N6756VFelicione Frank S Jr · Idaho Falls, IDFirst renewal noticeBuilt 1970 · S/N 700055 N67573Fixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1978 · S/N 15281921 N6757NCoody John A · Idaho Falls, IDBuilt 1968 · S/N 680071 N6757UScherger Mark A · Herndon, VABuilt 1963 · S/N 2479 N67582Jackson William Gary · Clinton, MDBuilt 1978 · S/N 15281928 N6758HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265570 N6758NZwerko Kevin C · South Plainfield, NJBuilt 1968 · S/N 680072 N6758UN6758u LLC · Linden, MIBuilt 1963 · S/N 2480 N67591Owen David A · Saint George, UTS/N 15281932 N6759UHodgson Michael D · Saint Francis, WIBuilt 1963 · S/N 2481 N675WMStoecklein Christine · Stanwood, WABuilt 2015 · S/N 1164-2015 N67601Aero Maintenance Inc · Vancouver, WABuilt 1978 · S/N 15281939 N67611Kumor Ronald G · Casper, WYBuilt 1978 · S/N 15281945 N67614Wampus Cats Inc · Davenport, IABuilt 1978 · S/N 15281948 N67618Hale Douglas W · Perryton, TXBuilt 1978 · S/N 15281950 N6761UJaeger Howard E · Claremore, OKBuilt 1963 · S/N 2483 N6762NTaylor Norman A · Fayette, ALBuilt 1968 · S/N 680076 N67638Blue Feathers Corp · Newark, DEBuilt 1978 · S/N 15281954

Back to AD 80-25-07 R1