Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573 N2474DDavidson Chad E · Roxton, TXBuilt 1952 · S/N 20626 N2474EBas Part Sales LLC · Greeley, COS/N 17271297 N2474JSingleton Addison L · New Bedford, MABuilt 1966 · S/N 15065574 N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674 N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774 N2474UPistor Elise D · Colleyville, TXBuilt 1963 · S/N 17250074 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355 N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775 N2475DGresley Ross A · Catawba, NCS/N 20627 N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361 N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362 N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363 N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364 N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365 N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776 N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576 N2476UFive States Holdings LLC · Helena, MTBuilt 1963 · S/N 17250076 N24773Grusy Norman D · Portland, ORS/N 15280369 N24775Cal Aggie Flying Farmers Inc · Davis, CABuilt 1977 · S/N 15280371 N2477GRamsey Stephen C · Aspen, COBuilt 1958 · S/N 51777 N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577 N24781Shaw Erin · Reno, NVBuilt 1977 · S/N 15280375 N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680 N2478GGilliland Sandra K · Julian, NCBuilt 1959 · S/N 51778 N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678 N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578 N2478UBraun Kevin J · Aberdeen, SDS/N 17250078 N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378 N2478YHockenson Roy D · Auburn, WABuilt 1962 · S/N 17249778 N2479CTo The Wind LLC · Salmon, IDBuilt 1954 · S/N 30779 N2479LMoore Joseph A · Kingwood, WVBuilt 1966 · S/N 17255679 N2479QPriest David E · Caldwell, IDBuilt 1966 · S/N 18257679 N2479U2479u Aviation LLC · Fernandina Beach, FLBuilt 1963 · S/N 17250079 N2479XKruse Interests LLC · League City, TXS/N 18256379 N2479YDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17249779 N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066 N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194 N247DLCentral Florida Flight LLC · Ocoee, FLBuilt 1966 · S/N 17254201 N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872 N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314 N2480DBush Joseph · Coalinga, CABuilt 1952 · S/N 20632 N2480GGassaway Mitchell E · Carrollton, TXBuilt 1959 · S/N 51780 N2480LStephens Ryan J · Dallas, PABuilt 1966 · S/N 17255680 N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2480URaczynski Adam · Far Rockaway, NYBuilt 1963 · S/N 17250080 N24816Graves James A Trustee · Norman, OKBuilt 1977 · S/N 15280396

Back to AD 87-20-03 R2