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.

N3466AClark Charles R · Mansfield, MOBuilt 1953 · S/N 22-1731 N3467ARay William R · Pasadena, CAS/N 22-1736 N3467Z67 Zulu LLC · Cherry Hill, NJBuilt 1960 · S/N 22-7391 N3468ASteffen Zacharey P · Lincoln, NEBuilt 1953 · S/N 22-1755 N3468PHilligoss Forrest R · Brownsburg, INBuilt 1958 · S/N 23-1442 N3469ZBerger Joyce F · Reno, NVBuilt 1960 · S/N 22-7394 N346RMHansen Alexander G · Glendale, CABuilt 1958 · S/N 24-929 N3474AHerring Adam · Navarre, FLBuilt 1953 · S/N 22-1750 N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449 N3478AVanmeter Ted A · Pleasanton, KSS/N 22-1747 N3482AJerzyk James D · Bradenton, FLBuilt 1953 · S/N 22-1748 N3487AOutka Wade R · Aberdeen, SDBuilt 1953 · S/N 22-1759 N3488ADanoff Michele A · Edgewater, MDBuilt 1952 · S/N 22-1760 N3489AZgurich Joseph S · Irwin, PABuilt 1953 · S/N 22-1761 N3490AFaibisoff Isaac J · Caseyville, ILBuilt 1953 · S/N 22-1762 N3491AKendrick Jack O · Weatherford, TXBuilt 1953 · S/N 22-1763 N3492ATautz Herb · Mount Carroll, ILBuilt 1953 · S/N 22-1764 N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197 N3494BLiguori Fred C · Granby, CTBuilt 1955 · S/N 23-282 N3497PKitchens Craig N · Salt Lake City, UTBuilt 1958 · S/N 23-1473 N3498AKell Matthew D · Kodiak, AKS/N 22-1770 N3499PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1475 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469 N34EECodingflyboy LLC · Hayward, CABuilt 1966 · S/N 30-1138 N34KKLe Ferrand Colette · Kalispell, MTBuilt 1972 · S/N 27-7304946 N34MIII Enterprises LLC · Britton, SDBuilt 1975 · S/N 31P-7630007 N34RABurke William G III · Fayetteville, GABuilt 1964 · S/N 30-342 N3500AHoller Leo F · Wasilla, AKBuilt 1953 · S/N 22-1772 N3500ZKuyk William P Sr · Holly, MIBuilt 1960 · S/N 22-7395 N3501ASargent Amanda L · Fort Lauderdale, FLS/N 22-1773 N3501PSjoberg Leonard C · Okemah, OKBuilt 1955 · S/N 22-3251 N3503ZMcmath Don · Collinsville, OKBuilt 1960 · S/N 22-7398 N3504ZHeadrick John E · Eolia, MOS/N 22-7399 N3506ARjr Airdrome Inc · Dover, DEBuilt 1953 · S/N 22-1778 N3507ZLaw T Wayne · West Point, UTBuilt 1960 · S/N 22-7402 N3508PJones Casey A · Princeton, KSBuilt 1955 · S/N 22-3258 N3509ASullivan Michael R · Crown Point, INS/N 22-1781 N350AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496575 N3510ZBetka Thomas C · Stevens Point, WIS/N 22-7406 N3511ZPogue Jimmy D · Owasso, OKBuilt 1960 · S/N 22-7407 N3513AKnudsen John M · Anchorage, AKS/N 22-1785 N3514AEastern Stearman Inc Trustee · Leesburg, VAS/N 22-1786 N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414 N3519ABandy Clyde T · Orlando, FLBuilt 1953 · S/N 22-1791 N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418 N351BBFinnerty Maurice E · Tabernacle, NJBuilt 1952 · S/N 20-867 N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274 N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420 N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275

Back to AD 85-02-05 R1