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.

N3522Barnett Charles J · St Peter JerseyBuilt 1969 · S/N 30-1787 N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276 N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277 N3524AGrd Aviation LLC · Canyon Lake, TXBuilt 1953 · S/N 22-1796 N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279 N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427 N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428 N3526ZSwett John P · Zebulon, NCBuilt 1960 · S/N 22-7429 N3527ASteinhoff Aaron M · Ethel, WABuilt 1953 · S/N 22-1799 N3528ASmith Carl D · Wilson, WIBuilt 1953 · S/N 22-1800 N3528PSalerno Joseph C Jr · Gettysburg, PABuilt 1955 · S/N 22-3283 N3530PYaroslavski Limited Partnership · Norman, OKBuilt 1955 · S/N 22-3286 N3531AHirkala Ronald R · New Cumberland, WVS/N 22-1803 N3532PBryan Curtis L · Enumclaw, WABuilt 1955 · S/N 22-3287 N3532ZMurphy Michael R Trustee · Syracuse, NYBuilt 1960 · S/N 22-7437 N3533AKilpatrick John N · Redding, CABuilt 1953 · S/N 22-1805 N3533ZSchwanebeck Derek D · Ellsworth, NEBuilt 1960 · S/N 22-7438 N3534AZimmerman Kenneth E · Eugene, ORBuilt 1953 · S/N 22-1806 N3535ADepoy Lowell K · Salem, INBuilt 1953 · S/N 22-1807 N3538PMachovsky Andrew J · Mesa, AZBuilt 1955 · S/N 22-3294 N3538ZEllis Grover D · San Ford, NCBuilt 1960 · S/N 22-7445 N3539PAdkins Clinton R · Corvallis, MTBuilt 1955 · S/N 22-3295 N3541PZang Peng · Mason, MIBuilt 1955 · S/N 22-3297 N3544PClark John W · New Philadelphia, OHBuilt 1955 · S/N 22-3300 N3545ARp Sky Ranch LLC · Lewes, DEBuilt 1953 · S/N 22-1819 N3546ZPerkins Todd M · Lake Alfred, FLBuilt 1960 · S/N 22-7455 N3548PHalley Dan R · Avery, TXBuilt 1955 · S/N 22-3304 N354PCLund Vern E · Madera, CABuilt 1964 · S/N 24-3611 N3550PYates Darren L · Collinsville, OKBuilt 1955 · S/N 22-3306 N3550ZMcmillian Dean R · Wasilla, AKBuilt 1960 · S/N 22-7461 N3551ZAlpine Cable & Construction Inc · Grand Junction, COBuilt 1960 · S/N 22-7462 N3552ZMccartney David J · Lake Stevens, WABuilt 1960 · S/N 22-7463 N3554ZJacobi Gregory A · Alex, OKBuilt 1960 · S/N 22-7465 N3556PPlanes & Things Inc · Collinsville, OKBuilt 1955 · S/N 22-3312 N3557AWalter Jerry Douglas II · Palm Beach Gardens, FLS/N 22-1831 N3557YNoble Stewart G · Reno, NVBuilt 1966 · S/N 30-1078 N3558AKra Investments LLC · Eastport, IDBuilt 1953 · S/N 22-1832 N3558PConly Vernon J · Lehigh Acres, FLBuilt 1955 · S/N 22-3314 N3559ZLapp Matthew J · Bonners Ferry, IDBuilt 1960 · S/N 22-7472 N355ABXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496093 N355FRD Hadjidemetriou Aviation Services Corp · Wilmington, DEBuilt 1975 · S/N 31P7530002 N355JPBryant Bruce B · Raymond, KSBuilt 1955 · S/N 22-3311 N355MDelaware Trust Company Owner Trustee · Wilmington, DES/N 273972 N3560ACoffee Barry L · Auke Bay, AKBuilt 1953 · S/N 22-1834 N3560PRichardson Billy J · Friendswood, TXBuilt 1955 · S/N 22-3316 N3560ZBolding Ronald B · Aguila, AZBuilt 1960 · S/N 22-7474 N3562AHedin Andrew D · Hutchinson, MNS/N 22-1836 N3562DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-8095014 N3563AHa Donggi · Lawrenceville, GABuilt 1953 · S/N 22-1837 N3565ZLewis William D · Shelbyville, TNBuilt 1960 · S/N 22-7480

Back to AD 85-02-05 R1