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.

N6476PSky Runner Aviation LLC · Wadsworth, OHBuilt 1959 · S/N 24-1592 N647ARankins Todd E · Mohawk, NYBuilt 1951 · S/N 22-50 N6480PCmc Aero LLC · Broken Arrow, OKS/N 24-1597 N6480YTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N 27-3776 N6482PCorson County Feeders Inc · Mc Laughlin, SDBuilt 1959 · S/N 24-1600 N6483PLee Charles C · New Buffalo, MIBuilt 1959 · S/N 24-1601 N6483ZSpokane Soaring Society · Spokane, WABuilt 1962 · S/N 25-2002 N6485YMeluskey Michael · Christiansted, VIBuilt 1967 · S/N 27-3782 N6486PBerg Alvin L · Overgaard, AZBuilt 1959 · S/N 24-1604 N6486ZSouthern Eagles Soaring Inc · Butler, GABuilt 1962 · S/N 25-2005 N6488PSooner Answer Service Inc · Edmond, OKS/N 24-1607 N648SCDeaton Dennis · Glen Allen, VAS/N 31P-7300143 N6494PPiehl Deborah C · Saint Petersburg, FLS/N 24-1614 N6494ZSoaring Club Of Houston · Waller, TXBuilt 1962 · S/N 25-2015 N6495PBarry Steven H · Monticello, UTS/N 24-1615 N6498PSinor Delbert · Ozark, MOS/N 24-1618 N6499PHoward John · Canon City, COBuilt 1959 · S/N 24-1620 N649SCDeaton Dennis · Glen Allen, VAS/N 31P-7400184 N64AZAlpha Zulu Tailwinds LLC · Fair Oaks, CABuilt 1964 · S/N 272753 N64EEConrad John E · Flower Mound, TXBuilt 1963 · S/N 24-3526 N64KBLee Scott D · Mcloud, OKBuilt 1959 · S/N 23-1665 N64MKraft Ronald S · Albuquerque, NMBuilt 1956 · S/N 23-534 N64PCReed Allan T · Danville, INBuilt 1963 · S/N 24-3583 N64TD377 Supplies LLC · Argyle, TXS/N 30-170 N64YBRegistration Pending · Wasilla, AKRegistration pendingS/N 30-331 N6500DAztec Adventures LLC · Cape Coral, FLBuilt 1960 · S/N 27-181 N6500PDennison Ronald Walton Trustee · San Jose, CABuilt 1959 · S/N 24-1621 N6501PGarcia Perez Alberto Carlos · Houston, TXBuilt 1964 · S/N 27-2489 N6502PMelvin Kelly G · Green River, WYBuilt 1959 · S/N 24-1623 N6503YShe-Rat Aviation Inc · Wilmington, DEBuilt 1967 · S/N 27-3791 N6504YLiebig Bryan H · Sacramento, CABuilt 1967 · S/N 27-3792 N6505PCaduda & Faulk Aero Ltd · Nederland, COBuilt 1959 · S/N 24-1626 N6507ZKnutson Wayne R · Tioga, NDS/N 25-2032 N650ATidewater Tailwheel LLC · Virginia Beach, VABuilt 1951 · S/N 22-53 N650PA-Z Leasing LLC · Kenosha, WIBuilt 1965 · S/N 27-2793 N6511PCaplinger James F · Battle Ground, WABuilt 1959 · S/N 24-1633 N6516PSchneringer Mitchell G DBA · Fremont, NEBuilt 1959 · S/N 24-1638 N6516ZAkima Logistics Services LLC · Colorado Springs, COS/N 25-691 N65173Boucher John C · Lakeside, AZBuilt 1963 · S/N 24-3492 N6517PJames Dennis · Pleasant Grove, CABuilt 1959 · S/N 24-1639 N6518PRubscha Rick L · Peoria, AZBuilt 1959 · S/N 24-1640 N6518YKiley Clement · Plainville, MAS/N 27-3808 N6518ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 25-2046 N651ABlauser Edward C · Mansfield, OHBuilt 1951 · S/N 22-54 N6520PMoffett Jules M DBA · Elmore, ALBuilt 1959 · S/N 24-1642 N6520ZWolter Randall R · Frederick, SDS/N 25-693 N6523PGoodin David · San Jose, CAFirst renewal noticeBuilt 1959 · S/N 24-1645 N6523ZWindy City Soaring Association · Hinckley, ILBuilt 1962 · S/N 25-2052 N6527YAll Pro Electrical Contractors Inc · Silsbee, TXBuilt 1967 · S/N 27-3800 N6528PSolomon Michael R · Taylor, AZBuilt 1959 · S/N 24-1650

Back to AD 85-02-05 R1