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.

N612CAOmni Aero LLC · Wilkesboro, NCBuilt 1978 · S/N 15282495 N612ERNelson James W · Lake Villa, ILBuilt 2018 · S/N 65-10237 N6130MKing Mike · Webster, TXFirst renewal noticeBuilt 1980 · S/N 15284627 N6132LSale Reported · Charles Town, WVSale reportedBuilt 1970 · S/N AA1-0332 N6133LBarnett George W · Salem, INBuilt 1970 · S/N AA1-0333 N6134LEuro 2000 Inc · Merritt Island, FLS/N 15284362 N6135QLake Effect Aviation LLC · Java Center, NYBuilt 1981 · S/N 15285159 N6136LTheriot Conchita F · Anderson, SCBuilt 1970 · S/N AA1-0336 N6139LGdg LLC · Lewes, DEBuilt 1970 · S/N AA1-0339 N6139MKelly David M · Issaquah, WAFirst renewal noticeBuilt 1980 · S/N 15284630 N613AMW & A Flight LLC · Greenville, SCBuilt 2004 · S/N 20-1038 N6141LJohnson Stephen M · Westlake, TXBuilt 1970 · S/N AA1-0341 N6143QSt Onge Andre E · Hooksett, NHBuilt 1981 · S/N 15285166 N6144LArtz Agri Sales LLC · Westhope, NDBuilt 1980 · S/N 15284364 N6145LMichaud Martin R · Monte Vista, CABuilt 1970 · S/N AA1-0345 N6146QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1981 · S/N 15285169 N6148LYoukey John N · Yuma, AZBuilt 1970 · S/N AA1-0348 N6149QGreen Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285172 N614BGNorth Star Aviation Inc · Mankato, MNBuilt 1980 · S/N 15284205 N614DVSpano David · Oswego, ILBuilt 1984 · S/N 1138 N6150LRucks Chad W · Okeechobee, FLBuilt 1970 · S/N AA1-0350 N6150MJprg Aviation Inc DBA · Orlando, FLBuilt 1980 · S/N 15284631 N6153LMastrangelo John A · Phoenix, AZBuilt 1970 · S/N AA1-0353 N6154QViman LLC · Bear, DEBuilt 1981 · S/N 15285174 N6155LPeterson Walter R · Appling, GABuilt 1970 · S/N AA1-0355 N6155QFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1981 · S/N 15285175 N6157LMelcher Robert L Trustee · Muskego, WIBuilt 1970 · S/N AA1-0357 N6159LLuciano Nicolas · Harlingen, TXBuilt 1970 · S/N AA1-0359 N6159NCrothall George · Oceanside, CABuilt 1978 · S/N 38-78A0069 N615ADHill Douglas L · Berrien Springs, MIBuilt 1946 · S/N 12-229 N615JSPollak Steven D · Cincinnati, OHBuilt 2003 · S/N 1388-2003 N6161LPlesetz Philip · Manitowoc, WIS/N AA1-0361 N6165LGjorvad Steven A · Punta Gorda, FLBuilt 1970 · S/N AA1-0365 N6170LCampbell Phillip · Fort Worth, TXS/N AA1-0370 N6171LGoode Stephen C · Canton, TXBuilt 1970 · S/N AA1-0371 N6172LKantor Dimitry · Essex, MDBuilt 1970 · S/N AA1-0372 N6174LHanson Alan L · Manchester, MIS/N AA1-0374 N6175HLafferty Dietrich Ian · Brooklyn, NYBuilt 1979 · S/N 15284138 N6175QKingsky Flight Academy LLC · Lakeland, FLS/N 15285184 N6179HCriss Enterprises LLC · Titusville, FLBuilt 1979 · S/N 15284139 N6180ZZeliff Aviation LLC · Batavia, NYS/N 831-72 N6182LHansen Karl G · Waxahachie, TXBuilt 1970 · S/N AA1-0382 N6183LPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N AA1-0383 N6188PFair Robert A · Bradford, PABuilt 1981 · S/N 15284984 N6189LKnutson Nathan J · Dubuque, IABuilt 1970 · S/N AA1-0389 N618KBCreech David W · Oriental, NCBuilt 2017 · S/N 0115234 N6192LTinaglia Aviation LLC · Hot Springs, SDBuilt 1970 · S/N AA1-0392 N6193LFly For Fun LLC · Rockville, MDBuilt 1980 · S/N 15284373 N6194QPnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285189 N61ADPrzybilla Michael L · Hettinger, NDBuilt 1990 · S/N 1776-L

Back to AD 80-25-02 R2