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.

N1703PCastillo Stephen P · San Antonio, TXBuilt 1954 · S/N 22-2490 N1707AParent Mark C · Blue Eye, MOBuilt 1952 · S/N 22-459 N1707TMoore Merritt T II · Silver Creek, NYBuilt 1955 · S/N 23-299 N1708PRaymond Harrison Donald · Camp Verde, AZBuilt 1954 · S/N 22-2495 N170TAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 27-7654005 N1715YPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654096 N1716AJacobs Dennis D · North Loup, NEBuilt 1952 · S/N 22-462 N1716PJones Gary L · Kerrville, TXBuilt 1954 · S/N 22-2506 N1717ARound Engine Aero · Nashville, MIS/N 22-466 N1718PMorris Christian A · Hood River, ORBuilt 1954 · S/N 22-2508 N171CAAircraft Parts Store LLC · Jacksonville, FLBuilt 2002 · S/N 4496131 N1723PQuinn Michael · Matthews, NCS/N 22-2513 N1724AMiller Billy E Sr · Dewitt, ARBuilt 1952 · S/N 22-482 N1726PSimonsen Joshua A · White Salmon, WABuilt 1954 · S/N 22-2516 N1727PBaker Geoffrey D · Philomath, ORBuilt 1954 · S/N 22-2517 N1728PHanft Alan K · Twentynine Palms, CABuilt 1954 · S/N 22-2518 N1730PHolbrook Jonathan L · Morehead, KYS/N 22-2520 N1731PLambert Wayne C · Canyon Lake, CABuilt 1954 · S/N 22-2521 N1736PRegistered aircraftBuilt 1954 · S/N 22-2526 N1740ABlair Philip S · Fowlerville, MIBuilt 1952 · S/N 22-477 N1741PWright Russell W · Ocala, FLBuilt 1954 · S/N 22-2531 N1748PHarbison Robert L · Willow, AKBuilt 1954 · S/N 22-2539 N175MBKlein Robert · North Garden, VABuilt 1959 · S/N 24-721 N175WMyrick Charles Henry · Maryville, MOBuilt 1956 · S/N 22-3910 N1761AVecchio Alfred J · Emerado, NDBuilt 1952 · S/N 22-490 N1764ALegge Carl D · Wichita, KSBuilt 1952 · S/N 22-495 N1765AMurray James A · Wasilla, AKBuilt 1952 · S/N 22-499 N176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496427 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N1771AAllen Timothy · Jackson, GAS/N 22-498 N1771PHansen Larry G · Alliance, NEBuilt 1954 · S/N 22-2543 N1772AAllen Jack · Deridder, LABuilt 1956 · S/N 22-502 N1773PWidman Ralph W · Lynchburg, OHBuilt 1954 · S/N 22-2545 N1774PBrandenburg Timothy C · Anchorage, AKBuilt 1954 · S/N 22-2547 N1775AChapman Harold J · Nenana, AKBuilt 1952 · S/N 20-865 N1779PWilliamson Gary T · Ashmore, ILBuilt 1954 · S/N 22-2552 N1788PBenson Thomas E · Keller, TXBuilt 1954 · S/N 22-2561 N178EGagan Samrat LLC · Charlotte, NCS/N 30-1727 N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028 N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028 N178UDavis Roger W · Felton, DEBuilt 1969 · S/N 30-1779 N178XSs Aviation LLC · Sulphur, LAS/N 30-1950 N1791PWhitley Brian M · Sandpoint, IDBuilt 1954 · S/N 22-2564 N1796PMcmahan C Merrill · Wausau, WIBuilt 1954 · S/N 22-2569 N1797PSherman John · Northport, NYBuilt 1954 · S/N 22-2570 N1799PGranger Joshua M · Rosebud, MTBuilt 1955 · S/N 22-2572 N17AFRolle Caraine A · Cypress, TXBuilt 1973 · S/N 27-7405291 N17AKFrancis Joseph · Kure Beach, NCBuilt 1978 · S/N 27-7854103 N17BDRegistered aircraftBuilt 1967 · S/N 30-1520 N17CMAbernathy Laurence K · Wills Point, TXBuilt 1964 · S/N 30-437

Back to AD 85-02-05 R1