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.

N3568ZUelner Nathan · Cedar Falls, IABuilt 1960 · S/N 22-7484 N3569AAlbright Larry W · Perkins, OKBuilt 1953 · S/N 22-1843 N3569ZKleewein Daniel A · Pewaukee, WIS/N 22-7485 N356CFCoast Flight Training And Management Inc · San Diego, CAS/N 447995282 N356HAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995004 N3573AAlderman Bill A · Chelsea, OKBuilt 1953 · S/N 22-1847 N3576ASolosky Robert L · North Barrington, ILBuilt 1953 · S/N 22-1850 N3579APerry John E · Kenai, AKBuilt 1953 · S/N 22-1854 N357CFCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 447995091 N357FPJenson Michael N · Nevis, MNBuilt 1961 · S/N 22-7334 N3580ARegistered aircraftS/N 22-1855 N3581ATriflyer Partners LLC · Garden Plain, KSS/N 22-1856 N3582ASindelar David C · Franklin, KYBuilt 1953 · S/N 22-1857 N3585AClement Jeffrey A · Abilene, TXBuilt 1953 · S/N 20-1085 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N359DWDurrell Lee W · Channel IslandsS/N 30-770 N359LULewis University · Romeoville, ILBuilt 2025 · S/N 4496596 N35ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1121 N35FASt Louis Soaring Association · Saint Louis, MOBuilt 1964 · S/N 253291 N3600PPaul Mike · Sprague, WABuilt 1955 · S/N 22-3321 N3600ZDay Charles W · Sedan, KSS/N 22-7488 N3601PCox Jay D · Perryton, TXBuilt 1955 · S/N 22-3323 N3601ZMid Atlantic Air Museum · Reading, PABuilt 1960 · S/N 22-7489 N3604AOlsen-Drye Robert C · Anchor Point, AKBuilt 1953 · S/N 22-1864 N3604PRegistration Pending · League City, TXRegistration pendingBuilt 1955 · S/N 22-3327 N3605ARhinehart Cody R · Knob Noster, MOS/N 22-1865 N3606ZLandreth Homer W · Peoria, AZBuilt 1960 · S/N 22-7494 N3607AMassey William R · Alturas, CABuilt 1953 · S/N 22-1867 N3608ZBingman William A · Depoe Bay, ORBuilt 1960 · S/N 22-7496 N3609ZVeal Petra L · Sterling, AKBuilt 1960 · S/N 22-7497 N360CFCoast Flight Training And Management Inc · San Diego, CAS/N 44-7995307 N360LDJohnson John · Omaha, NEBuilt 1954 · S/N 22-2335 N360LULewis University · Romeoville, ILBuilt 2021 · S/N 4496522 N3610ADid U Die Inc · Herrin, ILBuilt 1953 · S/N 22-1870 N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579 N3612PGoundry George D · Sammamish, WABuilt 1955 · S/N 22-3338 N3613AWarren Charles J · Sarver, PABuilt 1953 · S/N 22-1873 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N3616ARegistration Pending · Safford, AZRegistration pendingS/N 22-1876 N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344 N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723 N3621PCalkins David W · Janesville, WIBuilt 1955 · S/N 22-3354 N3622PPeck Gregory P · Harrisburg, PABuilt 1955 · S/N 22-3355 N3627ZHousel Thomas J · Pebble Beach, CABuilt 1960 · S/N 22-7519 N362BMAmerican Valet Air Inc · Wilmington, DEBuilt 1973 · S/N 27-7305171 N362BPLight & Variable LLC · Arlington, VABuilt 1979 · S/N 27-7954048 N3631PRoss Donald M · Fallbrook, CABuilt 1956 · S/N 22-3726 N3632PAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 24-3632 N3633AMartin Michael O · Frisco, TXBuilt 1954 · S/N 22-1891 N3635ZRiggi Dean A · Scotia, NYBuilt 1960 · S/N 22-7530

Back to AD 85-02-05 R1