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.

N5168XCulver Marc D · Anchorage, AKBuilt 1968 · S/N 616 N5168ZBrown Noah M · Tyler, TXS/N 22-8826 N5169XRegistration Pending · Palmer, AKRegistration pendingBuilt 1969 · S/N 676 N5169ZManning David G · Greenville, NCBuilt 1961 · S/N 22-8829 N5170THardison Aviation LLC · Hampton, SCBuilt 1966 · S/N 527 N5170XFitzpatrick Robert M · Fredericksburg, TXBuilt 1969 · S/N 677 N5171FElliot Gary L · Aguila, AZBuilt 1994 · S/N 1 N5171TGowins Steven M · Eagle, AKBuilt 1966 · S/N 563 N5172TJacksonville Aviation Group LLC · Jacksonville, FLBuilt 1966 · S/N 525 N5172XO'Daniel Mike · Elkhorn, NEBuilt 1969 · S/N 679 N5172ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8836 N5173TMorris Dennie R · North Fort Myers, FLBuilt 1966 · S/N 545 N5173XInabnit Michael S · Colville, WABuilt 1969 · S/N 680 N5173ZSvenningse Joshua J · Menomonie, WIBuilt 1961 · S/N 22-8837 N5174BSky Associates Inc · Jupiter, FLBuilt 1979 · S/N 15283790 N5174TMarnoch Kenneth S Trustee · Canyon Country, CAS/N 163 N5174ZSale Reported · Spearfish, SDSale reportedBuilt 1961 · S/N 22-8838 N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219 N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683 N5178ZUnderwood Robert D Jr · Randolph, NYBuilt 1961 · S/N 22-8842 N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139 N5180BRoberts Toney K · Batesville, MSS/N 6-6833 N5180ZScheer Paul G · Portland, ORBuilt 1961 · S/N 22-8846 N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508 N5183HLlewellyn John M · Grangeville, IDBuilt 1949 · S/N 14-501 N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890 N5184HReynolds Michael A · Fairbanks, AKBuilt 1949 · S/N 14-502 N5184ZCox Ronnie · Whitesburg, GABuilt 1961 · S/N 22-8851 N5185ZTroy Michael J · Albion, NYS/N 22-8852 N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276 N5186ZBearer Ronald C · Wimauma, FLBuilt 1961 · S/N 22-8853 N5187HJinnette Michael E · Lafayette, COS/N 14-505 N5187XBerkeland Jacob J · Bricelyn, MNBuilt 1969 · S/N 685 N5187ZCottrell Mark C · Leitchfield, KYS/N 22-8854 N5188XMullahy Patrick O · Burlington, IABuilt 1969 · S/N 686 N5189BFreedom Aviation Of America LLC · Newcastle, TXBuilt 1979 · S/N 15283797 N5189TZerck Joseph W · Anchorage, AKBuilt 1967 · S/N 199 N5189ZNorthwest Florida State College · Niceville, FLBuilt 1961 · S/N 22-8856 N5190XGawf Mike · Springdale, ARBuilt 1969 · S/N 690 N5191TLeonard Jon F · Glenn, CAS/N 300 N5191ZFlickinger Charles P · Hermitage, PABuilt 1961 · S/N 22-8859 N5193ZSchlosser Joseph V · Rockford, MNBuilt 1961 · S/N 22-8862 N5194ZTinsman Anthony L · Hartford, ARBuilt 1961 · S/N 22-8863 N5195TRainbow Flying Service LLC · Moses Lake, WAS/N 344 N5197ZPalmer Ralph Jr · Howard City, MIS/N 22-8867 N5199TOwens Roger A · San Antonio, TXBuilt 1967 · S/N 211 N5199ZLeister Tyler W · Norfolk, VABuilt 1961 · S/N 22-8869 N519QNewman C Keith · Cypress, TXBuilt 1978 · S/N AA1C0152 N51EVVan Bladeren Ronald W · Vancouver, WABuilt 1983 · S/N 550 N5201ZNunn Adam L · Abilene, TXBuilt 1961 · S/N 22-8871

Back to AD 80-25-02 R2