Skip to content

Registered aircraft · 10,639

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:99-01-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1') 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:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  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:99-01-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
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.

N49PRFurstenau Brock A · Tilden, NEBuilt 1949 · S/N 11-1007 N49RPSmiley Stephen P · Canandaigua, NYS/N 187909059 N49SLFun Airplanes LLC · Whitefish, MTS/N 12-1302 N49WVOleary Timothy M · Aliquippa, PABuilt 1949 · S/N 16-723 N4ETReilly Herbert V · Bloomingburg, NYBuilt 1946 · S/N 12-121 N4KBNichols Peter J · Soldotna, AKBuilt 1971 · S/N 18-8950 N4NWZink Matthew A · Dillingham, AKBuilt 1960 · S/N 22-7520 N4PRAlderman David D · Portland, TNBuilt 1952 · S/N 18-1828 N5000ZFinan Jeffrey J · Sammamish, WAS/N 22-8609 N5001HTucker Linda J · Wichita, KSBuilt 1948 · S/N 17-201 N5001ZSorby Steven R · Lyman, WAS/N 22-8610 N5002ZBuce Jake T · Kimberly, ORBuilt 1961 · S/N 22-8613 N5003HGospel Mission Aviation Inc · Ooltewah, TNBuilt 1948 · S/N 17-203 N5004HMeadows Robert D · Charles Town, WVBuilt 1948 · S/N 17-211 N5005HVollertsen Steve · Kenai, AKBuilt 1948 · S/N 11-878 N5005ZGerker David W · Fort Jennings, OHBuilt 1961 · S/N 22-8616 N5006Berry Milo A · Clarinda, IAS/N 11-888 N5006ZShort Colton R · Force, PABuilt 1961 · S/N 22-8617 N5007ZRabe John C · Lincoln, NES/N 22-8618 N5010HThompson Trent A · Forsyth, MTBuilt 1948 · S/N 11-873 N5010ZSchwagerman William C · Kingsville, MOBuilt 1961 · S/N 22-8621 N5011ZHarders Justin · Cairo, NES/N 22-8624 N5014HMercair Services Inc · Florahome, FLBuilt 1948 · S/N 11-849 N5014ZHicks Francis · Elizabeth, PABuilt 1961 · S/N 22-8629 N5015ZQuirk Charles Leo · Lake Charles, LABuilt 1961 · S/N 22-8630 N5018ZDowning John D · Marion, MIBuilt 1961 · S/N 22-8633 N5019ZCsapos Garry A · Ovid, MIS/N 22-8634 N501PWFlywerx LLC · Anchor Point, AKS/N 12-1445 N501ZNorth Georgia Helicopters Inc · Calhoun, GAS/N 18-7836 N5021ZFansler Rick L · Delta, OHBuilt 1961 · S/N 22-8636 N5022HChapman Doug S · Belgrade, MTBuilt 1949 · S/N 11902 N5023ZBauer Glenn D · Wishram, WABuilt 1961 · S/N 22-8638 N5025HWatson Jeffrey D · Anchorage, AKBuilt 1949 · S/N 11-905 N5025ZDean Charles William III · Boyle, MSBuilt 1961 · S/N 22-8640 N5026ZBrown Robert C III · Whiteville, NCBuilt 1961 · S/N 22-8641 N5029XHandyside Bryan P · Duluth, MNS/N 11-909 N5029ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8647 N5030HWharton Maya · Anchorage, AKBuilt 1949 · S/N 11-910 N5030ZBoring Walter A · Appomattox, VABuilt 1961 · S/N 22-8648 N5031HFrison Joyce · Whitewater, WIBuilt 1949 · S/N 11-911 N5033ZCada Kenneth C · Phoenix, AZS/N 22-8651 N5035ZAmish Peter S · Newberry, FLBuilt 1961 · S/N 22-8653 N5036HVan Winkle Randy M · Van Buren, MOS/N 11919 N5037HRegistered aircraftBuilt 1949 · S/N 11-920 N5037ZBoyd Christian K · Corinth, TXBuilt 1961 · S/N 22-8655 N5038HMeggers Roger D · Baker, MTS/N 11-921 N5039ZWeatherford John A · Kinder, LABuilt 1961 · S/N 22-8659 N5041ZNietfeld Roger C · Melrose, MNBuilt 1951 · S/N 18-585 N5042HGerman William E · Palmer, AKBuilt 1949 · S/N 11-925 N5042ZSmart Alan G · Lincoln, MEBuilt 1961 · S/N 22-8662

Back to AD 99-01-05 R1