Skip to content

Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N48WWSupercub Aviation LLC · College Station, TXBuilt 1976 · S/N E-940 N4902RBecker Flying Service Inc · Hartington, NEBuilt 1975 · S/N 18802420T N4902UWallace Randall · Stamps, ARFirst renewal noticeBuilt 1965 · S/N 21058602 N4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639T N4904UMcdonald Patrick B · Brownwood, TXBuilt 1965 · S/N 21058604 N4905AAnderson Ryan Alexander · Minnetrista, MNBuilt 1978 · S/N 310R1397 N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664 N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423T N4905UPerformance Ag Indiana · Frankfort, INS/N 21058605 N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425T N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643T N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609 N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039 N490DBPatkotak Crawford · Barrow, AKS/N U20604472 N490HPBreit Sky Aviation LLC · Sioux Falls, SDBuilt 1989 · S/N CE-1335 N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399 N490MLegacy Ofs Construction LLC · Stillwater, OKBuilt 1983 · S/N EA-390 N491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1978 · S/N 18503597 N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610 N4911CGianni David C · Fairbanks, AKBuilt 1975 · S/N 18502653 N4911ESchumacher Gregory Luther · Anchorage, AKBuilt 1979 · S/N 18503904 N4911JDarter Lloyd R · Mountain Grove, MOBuilt 1981 · S/N T18803778T N4913JPassmore Stephen B DBA · Lacrosse, WABuilt 1981 · S/N T18803780T N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613 N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649 N4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeBuilt 1965 · S/N 21058614 N4915CLang Carl R · Harper, TXBuilt 1975 · S/N 18502657 N4915VPegasus Aviation LLC · Rogersville, MOS/N 30139 N4916FSkaggs Steven L · Winters, CABuilt 1966 · S/N U206-0616 N4918QNauta Larry D · Soldotna, AKBuilt 1978 · S/N 18503575 N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160 N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046 N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673 N491BAirside Kc LLC · Riverside, MOBuilt 1974 · S/N TE-1012 N491SGryphon Ventures LLC · Apollo Beach, FLBuilt 2003 · S/N 0491 N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491 N4921FCa Aviation 172 LLC · Santa Barbara, CAS/N U206-0621 N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438T N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047 N4923CSmith Justin K · Wasilla, AKBuilt 1975 · S/N 18502659 N4924ENorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18503909 N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624 N4925CRichardson Richard E II · Windham, MEBuilt 1975 · S/N 18502660 N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371 N4927AGenx Aviation LLC · Leesburg, VABuilt 1978 · S/N 310R1504 N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662T N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627 N492TCMckinley Matthew · Sault Sainte Marie, MIBuilt 1971 · S/N 30362 N4930NOneill Aviation LLC · Lake Wales, FLBuilt 1977 · S/N 21062421 N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447T

Back to AD 86-13-04 R3