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.

N4865ZSchroer Steven K · Columbus, INBuilt 1961 · S/N 22-8442 N4868VKusy Edward James · Schulenburg, TXS/N 536 N48690Chamberlin William C · Williamsburg, MIBuilt 1977 · S/N 15280929 N4869LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284237 N48708Greene Caleb M · Laverne, CAS/N 15280934 N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834 N48710Conner Michael James · Scotts Valley, CABuilt 1977 · S/N 15280935 N48725Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280937 N4874BKoppelmann Kevin J · Cuba, MOS/N 15283687 N48751Tyau Jon S · Las Vegas, NVBuilt 1977 · S/N 15280951 N48753Harford Flying Club Inc · Kingsville, MDBuilt 1977 · S/N 15280952 N48757Stone To Glass LLC · Lake Worth, FLBuilt 1977 · S/N 15280956 N4875ZRice Gary W · San Antonio, TXBuilt 1961 · S/N 22-8454 N48762Carter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15283369 N48763Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280959 N48764Cohen Harold L · Pensacola, FLBuilt 1979 · S/N 15283370 N48768General Aviation Support Corp · Rosamond, CAS/N 15283371 N48779Bryan Robert G · Orland Park, ILBuilt 1977 · S/N 15280963 N48787Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15280967 N4878BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283689 N4879ZRobert P Brown Inc · Beatty, ORS/N 22-8460 N48810Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280976 N48816Feuerlein Maximilian · Tampa, FLBuilt 1977 · S/N 15280979 N48836Messenger Air Ltd · Madrid, IABuilt 1977 · S/N 15280993 N48842Elon Aviation LLC · Burlington, NCBuilt 1977 · S/N 15280997 N48848Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281000 N48856Neumeister Brian K · Edwardsville, ILBuilt 1977 · S/N 15281005 N4885ZReed Michael D · Parsons, KSBuilt 1961 · S/N 22-8467 N48868Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281013 N4886MPayne William E · Elizabeth, COBuilt 1947 · S/N 11411 N48878Kilo Lima Investments LLC · Huntington Beach, CABuilt 1978 · S/N 15281023 N48879Matson Dean R · Spring, TXBuilt 1977 · S/N 15281024 N48883Fly Kful Inc · Fullerton, CABuilt 1977 · S/N 15281026 N48887Fault Line Flyers · Leander, TXBuilt 1977 · S/N 15281030 N4888HRudisel Timothy A · Kewadin, MIBuilt 1979 · S/N 15283999 N4888LAshton Marc J · Petaluma, CABuilt 1980 · S/N 15284239 N48895Mulvania Rodney A · Linn, MOBuilt 1977 · S/N 15281037 N488EKingdom Air Corps · Sutton, AKBuilt 1977 · S/N 15279654 N48900Smtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 15283387 N48918Aero Fliers LLC · Kalispell, MTS/N 15283389 N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059 N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074 N48967N48967 LLC · Mount Pleasant, SCBuilt 1977 · S/N 15281079 N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083 N4898BPrecon Inc · Anaheim, CABuilt 1979 · S/N 15283697 N48990Hyldburg Aviation · Plymouth, MABuilt 1977 · S/N 15281090

Back to AD 80-25-02 R2