Skip to content

Registered aircraft · 6,348

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.

N1812FLynch Mark R · Forest Lake, MNBuilt 1981 · S/N WA-279 N1812ZHendrickson Todd R · Woodstock, ILBuilt 1981 · S/N WA-280 N1813GSenior Flyers LLC · Kalamazoo, MIBuilt 1968 · S/N 596 N1814NHenry Mark A · Dickinson, TXBuilt 1981 · S/N WA-282 N1814QWalsh Michael J · Clemmons, NCS/N WA-283 N18151Briggs James E · Nashua, NHBuilt 1981 · S/N WA-285 N1817GJacelon Charles E · Little River, SCBuilt 1968 · S/N 409 N1818GPine Wind Aviation LLC · San Francisco, CABuilt 1968 · S/N 561 N1819RWalsh Michael J · Clemmons, NCBuilt 1981 · S/N WA-296 N181HLJohn Chmura A & P LLC · Mount Pleasant, ARS/N 5 N181SYonge Robert R · Ocala, FLBuilt 1972 · S/N 266 N181TWatkins Steven B · Roxboro, NCBuilt 1953 · S/N 18-2295 N1820SClark Robert R · Covina, CABuilt 1981 · S/N WA-288 N1820WBoos Lynette J · Providence, RIBuilt 1981 · S/N WA-289 N1823YSpenner Herbert C · San Jose, CABuilt 1981 · S/N WA-290 N18242Huuki Matt · Atlantic Mine, MIBuilt 1981 · S/N WA-294 N18258Haas Edward L · Conroe, TXBuilt 1982 · S/N WA-299 N1825BKruse Adam L · Weiser, IDS/N 6252 N1826DDeoiveira Vitor · Shrewsbury, MABuilt 1983 · S/N WA301 N1827GSpangler Anthony J · Bethel, AKBuilt 1968 · S/N 587 N1831GGee3 LLC · Sardis, MSBuilt 1968 · S/N 600 N1831SCasson Christopher C · Klamath Falls, ORBuilt 1981 · S/N WA-302 N1836GJensen Steven M · Tioga, NDBuilt 1968 · S/N 595 N1837XCottrell Mark C · Leitchfield, KYBuilt 2016 · S/N 1837 N1842GOwen Dean W · Morehead, KYBuilt 1968 · S/N 585 N1848NMeserve Guy S · Sandpoint, IDBuilt 1982 · S/N WA-312 N185SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282935 N185SRHillbilly Holler LLC · Missoula, MTBuilt 1979 · S/N 15283215 N1862GEdwards Keith C · Gloversville, NYBuilt 1968 · S/N 649 N1866GNicollet Flying Club Inc · Nicollet, MNBuilt 1968 · S/N 445 N186TKing George W · Strykersville, NYBuilt 1953 · S/N 18-2300 N1872GMcninch Floyd S · Greenville, MES/N 614 N187RGBernhardt Fredrick W Jr · Lago Vista, TXS/N 1522 N18819Avest Ltd · Hilltop Lakes, TXS/N 10010 N1890AJohnson Air LLC · Anselmo, NEBuilt 1952 · S/N 18-1723 N1892GSveen Jeffrey S · Edinburg, NDS/N 612 N1893GDuston James D · Columbus, MSBuilt 1968 · S/N 619 N1894GWeyhe Joel J · Medford, ORBuilt 1968 · S/N 610 N1895GPost Morgan C · Council Bluffs, IABuilt 1968 · S/N 617 N189LJOrlowski Leo V · Cotter, ARS/N 4685 N189TNew London Taildraggers · Lynchburg, VABuilt 1953 · S/N 18-2303 N18BPRestall Brook E C · Debary, FLBuilt 1984 · S/N 1083 N18EZBryant Donald Kelly · Sullivan, MOBuilt 1992 · S/N JMS-01 N18GEHorvitz Martha E · Poway, CABuilt 1950 · S/N 18-227 N18HTTobler Niccolo Sunny · Anchorage, AKS/N 15282364 N1906LMosher David A · Pacifica, CABuilt 2016 · S/N 1906 N190BWheaton Joshua L · Denver, COBuilt 1999 · S/N 760 N1913JHaugo Bruce K · Sarasota, FLS/N 4J N1919EPoklar Norman A · Mount Orab, OHBuilt 1957 · S/N 7AC-5486 N191FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285939

Back to AD 80-25-02 R2