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.

N5541ZSpivey Harold E · Thomaston, GABuilt 1961 · S/N 22-8958 N5543KClassic Aviation LLC · Richmond, MIBuilt 1978 · S/N 1256-78 N5543ZKiendl Philip R · Carabaset Vly, MEBuilt 1962 · S/N 22-9334 N5544LRegistration Pending · Troy, NYRegistration pendingBuilt 1980 · S/N 15284347 N5544ZBetween The Seams Inc · Locust Grove, GABuilt 1962 · S/N 22-9335 N5545Javelo LLC · Ash Flat, ARBuilt 2015 · S/N 7792 N5545ZPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 22-9337 N5548LUnruly Passengers LLC · Piedmont, SCBuilt 1980 · S/N 15284350 N5548ZJurgens Noel G · Mound City, KSFirst renewal noticeBuilt 1962 · S/N 22-9340 N5549ZRegistration Pending · Bloomsburg, PARegistration pendingBuilt 1962 · S/N 22-9341 N5550ZShippers Michael S · Williamson, NYBuilt 1962 · S/N 22-9342 N5551HLeavengood Thomas Richard · Dallas, IABuilt 1949 · S/N 11-1062 N5551LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284353 N5551ZKons Emily Ap · Bear Creek, WIBuilt 1962 · S/N 22-9343 N5552KMob Aviation LLC · Auburndale, FLBuilt 1978 · S/N 1257-78 N5552MRegistration Pending · Fayetteville, TNRegistration pendingBuilt 1980 · S/N 15284613 N5554ZWeddle Curtis E · Iowa Park, TXBuilt 1962 · S/N 22-9347 N5555ZKramer Brian J · Seattle, WABuilt 1962 · S/N 22-9348 N555BJGypsy Aviation LLC · Newnan, GAS/N 182 N555STSweeney Steven · Avon, COBuilt 1979 · S/N 15283493 N5561ZHoward David D · Winner, SDBuilt 1962 · S/N 22-9358 N5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1962 · S/N 22-9360 N5566ZAlex Lawrence P · Loves Park, ILBuilt 1962 · S/N 22-9363 N5569ZLevandowski Joseph · Hamburg, NYBuilt 1962 · S/N 22-9273 N556MKPickering Gordon D · La Pine, ORBuilt 2001 · S/N 294 N5570ZShippers Lee D · Wolcott, NYBuilt 1962 · S/N 22-9364 N5571ZGlass John · San Luis Obispo, CABuilt 1962 · S/N 22-9366 N5572ZGilmer Rickey W · Cropwell, ALBuilt 1962 · S/N 22-9369 N5573ZHerrick David · Mont Vernon, NHBuilt 1962 · S/N 22-9373 N5574HAjmi Amal R · Fairbanks, AKBuilt 1949 · S/N 11-1099 N5575ZLareaux Jon R · Calumet, MIS/N 22-9375 N5577ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1962 · S/N 22-9378 N557CGGoss Carmon G · Mc Clure, PABuilt 1947 · S/N 12-2215 N5580ZMorrow G Warren · Center, MOS/N 22-9382 N5582ZStottlemyer Bradley J · Lake Geneva, WIBuilt 1962 · S/N 22-9387 N5583ZWoods Robert L · Kenly, NCBuilt 1962 · S/N 22-9390 N5584ZDerrico Andrew D · Leesburg, FLS/N 22-9393 N5585ZHeitz John W · Manvel, TXBuilt 1962 · S/N 22-9394 N5586ZKoenig Anthony Scott · Huntsville, TXBuilt 1962 · S/N 22-9395 N5587ZWeesies Jack · Saint Petersburg, FLBuilt 1962 · S/N 22-9396 N5588ZSpooner John A · Hickory, NCBuilt 1962 · S/N 22-9397 N5589ZDayton Stephen G · Littleton, NHBuilt 1962 · S/N 22-9399 N5590ZWhitaker Shawn P · Mount Pleasant, SCBuilt 1962 · S/N 22-9400 N5593ZEastern Stearman Inc Trustee · Leesburg, VABuilt 1962 · S/N 22-9404 N5596ZLamb Steve E · Big Bear City, CABuilt 1962 · S/N 22-9407 N5598ZEkstrom David L · Bemidji, MNBuilt 1962 · S/N 22-9409 N55AHHancock James T · South Saint Paul, MNBuilt 1978 · S/N 5555 N55AMAdams Floyd R · Sebring, FLBuilt 1966 · S/N 362 N55DVDevine William L Jr · Maple Falls, WABuilt 1948 · S/N 14-192 N55PMOrgis Brian E · Houston, TXBuilt 1987 · S/N 1558

Back to AD 80-25-02 R2