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.

N2489MBarker Gerald E · Weymouth, MAS/N 12-1695 N2489NDeschamps Joseph L · Barre, MABuilt 1979 · S/N 38-79A0871 N248TGiannonatti Lance A · Ludlow, SDBuilt 1953 · S/N 18-2362 N24905Cochran David · Richmond, KSBuilt 1939 · S/N 3528 N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445 N2490VPiper Aircraft Inc · Vero Beach, FLBuilt 1982 · S/N 38-82A0068 N24914Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0017 N2491CPearlman Lawrence A · South Boston, VABuilt 1978 · S/N 38-79A0203 N2491FCarlson Dann S · Kailua, HIBuilt 1979 · S/N 38-79A0477 N24920Springett Justin · Boulder, COS/N 15280450 N2492MSchaaf Terry L · Bowman, NDBuilt 1947 · S/N 12-1699 N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456 N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457 N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459 N2493MDriver Kegan Thomas · Billings, MTS/N 12-1561 N24947Aty Aviation Inc · Watertown, SDS/N 15280464 N2494BMunger Steven D · Mifflintown, PABuilt 1978 · S/N 38-79A0092 N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467 N2495APhillipine Matthew · Bonita Springs, FLBuilt 1978 · S/N 38-78A0715 N2495DGutierrez Roberto R Jr · Edinburg, TXBuilt 1978 · S/N 38-79A0333 N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490 N24986Charlston Michael M · Haleiwa, HIBuilt 1977 · S/N 15280495 N2498DGenzlinger Chad A · Foresthill, CABuilt 1978 · S/N 38-79A0334 N24995Stiles Robert K · Lynden, WABuilt 1977 · S/N 15280502 N24998Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280503 N2499AEhrich Anthony K · Rockham, SDS/N 38-78A0718 N2499MC & C Sierra LLC · Jackson, WYBuilt 1947 · S/N 12-1566 N2499PPancio Paul · Lagrangeville, NYS/N 38-79A1013 N249KJBarnett Alan S · Silver Spring, MDBuilt 1993 · S/N 293 N24DTMowad Gary G · Scottsdale, AZBuilt 1995 · S/N 113 N24PNCentinaro Paul Joseph · Lonoke, ARS/N 479 N24PSLewis University · Romeoville, ILBuilt 2003 · S/N 1394 N24SKCarter Scott P · Dallas, TXS/N 1255 N24WVEvenson Douglas W · Pine Mountain, GABuilt 1994 · S/N 04 N24ZASmart Guys Computing LLC · Chandler, AZBuilt 1996 · S/N 200024 N2500ERudloff Uwe K Trustee · Lake Village, INS/N 38-78A0474 N2501ZSmith Glenn G Jr · Ardmore, OKBuilt 1977 · S/N 1219-77 N25023Linero Jose J · San Juan, PRBuilt 1979 · S/N 38-79A0984 N25028East Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 15280505 N2503PAlpha Aviation Holdings Group LLC · Raleigh, NCS/N 38-79A1014 N2503VAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0069 N25047Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280514 N2504MAerial Messages Leasing Co · Longwood, FLBuilt 1946 · S/N 12-1002 N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517 N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520 N2505KIvy James E · Alba, TXBuilt 1979 · S/N 38-79A0669 N25062Stratton James P · Lubbock, TXBuilt 1979 · S/N 38-80A0026 N2506GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 38-79A0547 N2506LColumbus State Community College · Columbus, OHBuilt 1979 · S/N 38-79A0740 N2507AMann Robert M · Royal Oak, MIBuilt 1978 · S/N 38-78A0722

Back to AD 80-25-02 R2