Skip to content

Registered aircraft · 6,349

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

N757AHRed Sky Aviation LLC · Livermore, CABuilt 1977 · S/N 15279582 N757AJSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279583 N757AKSloan Kyle C · Anchorage, AKBuilt 1950 · S/N 18-278 N757AYAdams Steve G · Watsonville, CABuilt 1977 · S/N 15279597 N757AZKilo Aviation LLC · East Peoria, ILS/N 15279598 N757BBKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 15279600 N757BFOld Goat LLC · Wilmington, DEBuilt 1977 · S/N 15279604 N757BKPfister Mark A · Acworth, GABuilt 1977 · S/N 15279608 N757BS4 One Air LLC · Holland, MIBuilt 1977 · S/N 15279615 N757BVPlayer Dennis M · Union Bridge, MDS/N 15279618 N757BWK2 Sales LLC · Idaho Falls, IDS/N 15279619 N757CQPorter Casey · Bluffton, SCBuilt 1977 · S/N 15279636 N757CTAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279639 N757DAHuston Wes · Sanger, TXBuilt 1977 · S/N 15279646 N757DEMavity Michael D · Phoenix, AZBuilt 1977 · S/N 15279650 N757DFWisener Lupita A · Mineola, TXBuilt 1977 · S/N 15279651 N757DQIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1977 · S/N 15279660 N757DSCummings Scott A · Monitor, WABuilt 1947 · S/N 12-2745 N757DTStar City Aviation Inc · Roanoke, VAS/N 15279663 N757EHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279677 N757ENMontana Flying Service LLC · Missoula, MTBuilt 1977 · S/N 15279682 N757EVRoth Michael L · Lanse, MIBuilt 1977 · S/N 15279689 N757EWMagin Sonny K · Harvest, ALS/N 15279690 N757EXRound Engine Aero · Nashville, MIS/N 15279691 N757FCBoland Matthew S · Anchorage, AKBuilt 1977 · S/N 15279696 N757FDR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15279697 N757FEMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15279698 N757FFAir-Planes LLC · Soddy Daisy, TNS/N 15279699 N757FHSilverman Mitchell G · Cumberland, RIBuilt 1977 · S/N 15279701 N757FJGeorge Alexander Vasil Jr · Haverhill, MABuilt 1977 · S/N 15279702 N757FQMundis William L · York, PABuilt 1977 · S/N 15279708 N757GNExecutive Wings LLC · Bolivar, TNBuilt 1977 · S/N 15279730 N757GQAngel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15279732 N757GXWinging It Aviation Two LLC · Gulf Shores, ALBuilt 1977 · S/N 15279739 N757HAKim Sungtae · Fort Worth, TXS/N 15279742 N757HCBaker David L · Leavenworth, KSBuilt 1977 · S/N 15279744 N757HERussell Robert Q · Genoa City, WIBuilt 1977 · S/N 15279746 N757HHA&R Aero LLC · Sacramento, CAS/N 15279749 N757HMSchmitt Rudy · Brookshire, TXS/N 15279753 N757HTParrish Aviation Flight Academy LLC · Southlake, TXS/N 15279759 N757HVPropel Air LLC · Pottstown, PABuilt 1977 · S/N 15279761 N757HXAppalachian Aviation LLC · Harrisonburg, VABuilt 1977 · S/N 15279763 N757HYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279764 N757JDSuburban Air Corp · Castro Valley, CABuilt 1977 · S/N 15279769 N757JGJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279772 N757JJJetstream Aeronautics LLC · San Antonio, TXBuilt 1977 · S/N 15279774 N757JKMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 15279775 N757JXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279787 N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788 N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795

Back to AD 80-25-02 R2