Skip to content

Registered aircraft · 8,920

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:85-02-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') 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:85-02-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
  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:85-02-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
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.

N5725ZHolt Gary E · Sandusky, OHBuilt 1963 · S/N 22-9564 N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802 N5729DLanzara Anne M · Salem, VABuilt 1956 · S/N 22-4427 N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803 N572ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496194 N572PUTrustees Of Purdue University · West Lafayette, INBuilt 2024 · S/N 4496583 N5731DBamford Gregory R · Pace, FLBuilt 1956 · S/N 22-4431 N5731ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1963 · S/N 22-9570 N5732DAerospace Center For Excellence Inc · Lakeland, FLBuilt 1956 · S/N 22-4432 N5733PStrattner Brian J · Chesapeake, VABuilt 1959 · S/N 24-807 N5735ZCrouch Michael G · Brazoria, TXBuilt 1963 · S/N 22-9574 N5736ZMiller Andy D · Marana, AZBuilt 1963 · S/N 22-9575 N5739DSmith James A · Lyle, WABuilt 1956 · S/N 22-4439 N573ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496198 N573PUTrustees Of Purdue University · West Lafayette, INBuilt 2024 · S/N 4496584 N5740YJts Aero LLC · New Hampton, NYS/N 27-2864 N5740ZLashley Chad P · Wentzville, MOBuilt 1963 · S/N 22-9579 N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441 N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442 N5742YAustin Mario A · Charlotte Amalie, VIBuilt 1965 · S/N 27-2867 N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444 N5745PMiller Aaron T · New Braunfels, TXS/N 24-819 N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820 N5746YM C Flyers Inc · Port Orange, FLBuilt 1965 · S/N 27-2871 N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447 N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823 N5749ZTroy Michael J · Albion, NYBuilt 1963 · S/N 22-9588 N574ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496199 N574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273 N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825 N5750ZFaux George F 11 · Newcastle, MEBuilt 1963 · S/N 22-9592 N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826 N5752YShackelford John S Jr · Roanoke, TXS/N 27-2877 N57539Registration Pending · Meriden, CTRegistration pendingBuilt 1976 · S/N 31P-7630002 N5754DRocca John · Box Elder, SDS/N 22-4454 N5754ZKumley William A · Camarillo, CABuilt 1963 · S/N 22-9596 N5755DNathan Timothy A · Arnold, MDBuilt 1956 · S/N 22-4455 N5755ZSkibinski James J · Senoia, GABuilt 1963 · S/N 22-9597 N57585Sabbe Bros Flying Service Inc · Maddock, NDBuilt 1975 · S/N 36-7560119 N57589Sabbe Bros Flying Service Inc · Maddock, NDBuilt 1975 · S/N 36-7560122 N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834 N5758ZColt 135 LLC · Lexington, NEBuilt 1963 · S/N 22-9600 N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836 N5759ZBuds Auto Parts Ltd · Gowen, MIBuilt 1963 · S/N 22-9601 N575ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496203 N57609Lazy T Aviation LLC · Ashland, NEBuilt 1975 · S/N 36-7660009 N5760PLoughlin Robert J · Midland, TXBuilt 1959 · S/N 24-838 N57615Newkirk Thomas R · Garland, NCBuilt 1975 · S/N 36-7660014 N57625Stratham Aerial Spraying LLC · Axtell, KSBuilt 1975 · S/N 36-7660022 N5762ZGulley Gordon L · Manteno, ILS/N 22-9604

Back to AD 85-02-05 R1