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.

N22135Rosales Ruano Irving A · Plantation, FLS/N 15068084 N22138Obert Robert V · Dunnellon, FLBuilt 1967 · S/N 15068086 N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513 N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513 N2213JKlemp Darrel D · Bonduel, WIBuilt 1966 · S/N 15065413 N22142Cummings Ezekiel · San Antonio, TXBuilt 1967 · S/N 15068090 N22145Mcdowell Jhonathon P · Lake Alfred, FLBuilt 1967 · S/N 15068093 N22146Star Voyages LLC · Kissimmee, FLBuilt 1967 · S/N 15068094 N22147Morris Gregory A · Arlington, TXFirst renewal noticeBuilt 1967 · S/N 15068095 N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514 N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514 N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014 N22150Cody Edward H · Benton City, WABuilt 1967 · S/N 15068098 N22151Soren Sky LLC · Riverside, CAS/N 15068099 N22153Carter Gary J · Manlius, NYBuilt 1967 · S/N 15068101 N22155Anady Aviation LLC · Hemet, CABuilt 1967 · S/N 15068103 N22157Potter Colin J · Piedmont, SDBuilt 1967 · S/N 15068104 N22158Million John B · Westminster, MDBuilt 1967 · S/N 15068105 N22159Registration Pending · Phoenix, AZRegistration pending, canceledBuilt 1967 · S/N 15068106 N2215JRogers Gary A · Novi, MIBuilt 1966 · S/N 15065415 N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367 N22160Evert Linda L · Golden Valley, MNBuilt 1967 · S/N 15068107 N22162Red Oak Commuter LLC · Red Oak, IABuilt 1967 · S/N 15068108 N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516 N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504 N2216URegistered aircraftBuilt 1974 · S/N U20602355 N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116 N22170Taylor Warren D · Las Vegas, NVBuilt 1967 · S/N 15068114 N22172Soerens Thomas D · Saint Charles, ILBuilt 1967 · S/N 15068115 N22177Gedney Douglas Kevin · Grand Haven, MIBuilt 1976 · S/N 177-02323 N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230 N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N22183Allworth Burton · Wapello, IAS/N 15068121 N2218CMart Gary A · Bend, ORS/N 30518 N2218YDoran Jeffrey T · Westerville, OHS/N 17700018 N22190Mulhall Kathy · Fishtail, MTBuilt 1967 · S/N 15068127 N22191Perry Oien · Deadwood, SDBuilt 1967 · S/N 15068128 N22192Pecinovsky Clair · Cresco, IABuilt 1967 · S/N 15068129 N22194Schmidt James P · Omaha, NEBuilt 1967 · S/N 15068130 N22196Showah Michael F · Scottsdale, AZBuilt 1967 · S/N 15068132 N22197Frallicciardi Vincent Jtrust · Madawaska, MEBuilt 1967 · S/N 15068133 N2219CCarder Kent E · Lakeville, MNBuilt 1953 · S/N 30519 N2219DRogers David R · Lake Jackson, TXBuilt 1952 · S/N 20371 N2219ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271189 N2219JMcnamara Bradley W · Seattle, WABuilt 1966 · S/N 15065419 N2219TDls Holdings Inc · Arlington, TXBuilt 1968 · S/N 185-1371 N221AGryczewski John · Olive Branch, MSBuilt 1956 · S/N 28413 N221AARegistered aircraftBuilt 1977 · S/N 21062293 N221AKRegistration Pending · Oakwood, OHRegistration pendingBuilt 1966 · S/N 188-0184

Back to AD 87-20-03 R2