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.

N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864 N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236 N2330GEmshwiller Mark E · Camp Verde, AZBuilt 1958 · S/N 51630 N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455T N2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230 N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866 N2331DJensen William C · Brookshire, TXBuilt 1952 · S/N 20483 N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531 N2331GSouth Bay Aviation Inc · Torrance, CAS/N 51631 N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431 N2331SMiller Randy L · Enid, OKS/N 337-0631 N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873 N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874 N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875 N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876 N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2332DSandstrom David · Anchorage, AKBuilt 1952 · S/N 20484 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632 N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132 N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878 N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880 N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2333DTroutman Charles W · Prineville, ORBuilt 1952 · S/N 20485 N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633 N2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N U20603676 N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233 N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133 N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888 N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890 N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891 N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153 N2334DCaruso Timothy E · Gainesville, VABuilt 1952 · S/N 20486 N2334USimplifly LLC · Mesa, AZBuilt 1962 · S/N 17249934 N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085 N23357603 Flight LLC · Nashua, NHS/N 15068898 N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900 N2335DWinch Cary F · Necedah, WIS/N 20487 N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240 N2335FGravitte Peter F · Napa, CAS/N 21058535 N2335GRegistered aircraftBuilt 1958 · S/N 51635 N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901 N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904 N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905 N2336GLogue Elmer S · Derby, KSS/N 51636 N2336UWilson Milledge L · Prosperity, SCBuilt 1962 · S/N 17249936 N2337Boutique Air Inc · Denver, COBuilt 1969 · S/N 337-1102

Back to AD 87-20-03 R2