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.

N2314GFallang Paul Sam · Great Falls, MTBuilt 1959 · S/N 51614 N2314RWilson George L · Hideaway, TXBuilt 1964 · S/N 18255414 N2314UCms Crawford Maintenance Services LLC · Largo, FLBuilt 1962 · S/N 17249914 N2314XFlight Resources LLC · Monroe, GABuilt 1965 · S/N 18256214 N23153Riser Natalia Lang · Montgomery, TXBuilt 1968 · S/N 15068757 N23156Brooks Clifton B · Harrah, OKBuilt 1968 · S/N 15068759 N23157Hubler Eric William · Caldwell, IDBuilt 1968 · S/N 15068760 N23158Schumacher James A · Woodinville, WABuilt 1968 · S/N 15068761 N2315CRegistered aircraftBuilt 1953 · S/N 30615 N2315DFeher Eugene A · Greenwich, NYBuilt 1952 · S/N 20467 N2315FRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1964 · S/N 21058515 N2315GClark Jeffrey E · Tiburon, CABuilt 1958 · S/N 51615 N2315XParker Ronald Lewis · Melissa, TXBuilt 1965 · S/N 18256215 N23162Dillon R Patterson Professional Services LLC · Prescott, AZBuilt 1968 · S/N 15068763 N23167Walker Timothy M · Brockport, NYBuilt 1968 · S/N 15068765 N2316CTwo Wings LLC · Anchorage, AKBuilt 1953 · S/N 30616 N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516 N2316YWhitacre James P · Martinsburg, WVBuilt 1967 · S/N 17700116 N23174Stewart Ellen D · Trafalgar, INBuilt 1968 · S/N 15068771 N2317GOrion Aviation LLC · Edmond, OKS/N 21061485 N2317XSproul Wendell C · Hermon, MEBuilt 1965 · S/N 18256217 N23187Pollauf James W · Northwood, OHBuilt 1968 · S/N 15068780 N23188Reginald Caudill · Hi Hat, KYBuilt 1968 · S/N 15068781 N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618 N2318FBe Dozer LLC · Guy, ARS/N 21058518 N2318GRedmond John R · Reno, NVS/N 51618 N2318RJigamian Geoffrey T · Temecula, CABuilt 1964 · S/N 18255418 N23193Smith Roger D · Fayetteville, NCBuilt 1968 · S/N 15068785 N23197Martin Michael E · Doniphan, MOBuilt 1968 · S/N 15068787 N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519 N2319GSkydive Co · Fairburn, GABuilt 1958 · S/N 51619 N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245 N2319UGriffin Edward L · Bowling Green, KYBuilt 1962 · S/N 17249919 N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551 N231SCBice Crystal Harmon · Temple, GABuilt 1974 · S/N 17264523 N23205Registration Pending · Orchard, IARegistration pendingBuilt 1968 · S/N 15068790 N23206Schwind Bernard J · Kaunakakai, HIBuilt 1968 · S/N 15068791 N2320DBeyer James C · Fayetteville, TNBuilt 1952 · S/N 20472 N2320ESky Farmer LLC · Culleoka, TNS/N 17271232 N2320GStocker Earnest E · Krum, TXBuilt 1959 · S/N 51620 N23218Registration Pending · Utica, KYRegistration pendingBuilt 1968 · S/N 15068801 N2321FMilson Charles · Sanford, NCBuilt 1964 · S/N 21058521 N23221Bartosh David W · Abbott, TXBuilt 1968 · S/N 15068803 N23228Johnston David W · Vero Beach, FLBuilt 1968 · S/N 15068809 N2322CTwin Otter Internatinal Ltd · Las Vegas, NVBuilt 1953 · S/N 30622 N2322DMacvey Troy R · Milan, INBuilt 1952 · S/N 20474 N2322GBaker Harry K · Phoenix, AZBuilt 1958 · S/N 51622 N2322RSink Lendon V · Lexington, NCBuilt 1964 · S/N 18255422 N23231Jones Robert A · Smyrna, DEBuilt 1968 · S/N 15068811 N23232Ozment Dennis W · Palmyra, MOBuilt 1968 · S/N 15068812

Back to AD 87-20-03 R2