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.

N850ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496568 N8510DShipley Steven D · Masterson, TXBuilt 1957 · S/N 22-5737 N8510LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1969 · S/N 25-4925 N8511CWingsesprit · Columbus, NDBuilt 1953 · S/N 22-1219 N8511PWiebe Aron F · Seminole, TXBuilt 1965 · S/N 26-91 N8512YSager Garrett · Fort Worth, TXBuilt 1967 · S/N 30-1672 N8513DRowland Nathan A · Lascassas, TNBuilt 1957 · S/N 22-5740 N8513YCrane Douglas Gordon · Coquille, ORBuilt 1967 · S/N 30-1673 N8514DBecker Gloria J Personal Representative · Gladwin, MIBuilt 1957 · S/N 22-5741 N8514LSugarbush Soaring Assn Inc · Warren, VTBuilt 1969 · S/N 25-4931 N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675 N8515PJohnson Gary Paul · West Jordan, UTBuilt 1964 · S/N 26-52 N8515YPiper Aviation Museum Foundation · Lock Haven, PABuilt 1967 · S/N 30-1676 N8516DBass Edward L · San Angelo, TXBuilt 1957 · S/N 22-5743 N8517CFrance Gary L · West Salem, OHS/N 22-1228 N8518CBoesl Shawn W · Aberdeen, SDBuilt 1953 · S/N 20-993 N8518DWood Michael · Port Saint Lucie, FLBuilt 1957 · S/N 22-5745 N8519LChicago Glider Club · Minooka, ILS/N 25-4937 N8519PHubbard William A · Blair, OKS/N 26-99 N851ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496569 N851NDSkymates Inc · Wilmington, DEBuilt 1989 · S/N 4495005 N851PAFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1957 · S/N 23-851 N8520CRitzman Todd F · Pewaukee, WIBuilt 1953 · S/N 20-995 N8520PJones Terry W · Houston, TXBuilt 1965 · S/N 26-100 N8522CParylak Sean P · Colchester, CTBuilt 1953 · S/N 22-1230 N8522DAdams Daryl S · Monticello, FLBuilt 1957 · S/N 22-5750 N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684 N8524DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5752 N8525PThorstenson Joseph · Norwalk, CTBuilt 1965 · S/N 26-105 N8526PFisher Robin D · Corona, CABuilt 1964 · S/N 26-106 N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687 N8526ZRyther John W · Austin, MNBuilt 1952 · S/N 20-900 N8527CRegistered aircraftBuilt 1953 · S/N 22-1237 N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688 N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689 N852NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 4495006 N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758 N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691 N8533PJacobs Aviation LLC · Mount Juliet, TNS/N 26-114 N8534CSalter Christopher D · Elberta, ALBuilt 1953 · S/N 22-1239 N8535PSecond Life Flight Inc · Delray Beach, FLBuilt 1964 · S/N 26-116 N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696 N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768 N8536PBaker Gary J Trustee · Stateline, NVBuilt 1965 · S/N 26-117 N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769 N8538PNovo Rafael E · Edgewood, NMBuilt 1965 · S/N 26-119 N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606 N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770 N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626 N8540LMid Mo Ag Air LLC · Boonville, MOBuilt 1969 · S/N 25-4961

Back to AD 85-02-05 R1