Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N50434Summerville Daniel · Millersville, MDBuilt 1968 · S/N 15069301 N50438Roche Thomas A · Bardstown, KYBuilt 1968 · S/N 15069303 N5043AStephens Zachary L · Big Lake, AKS/N 28043 N5044APatzanakidis Konstandinos · Jupiter, FLBuilt 1955 · S/N 28044 N5045KCappiello Bob M · Santa Clarita, CAS/N 1 N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322 N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324 N5046AHappy Landings Aviation LLC · Maple, NCBuilt 1955 · S/N 28046 N5046HDavis James E · Belle Fourche, SDBuilt 1949 · S/N 11-928 N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327 N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329 N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330 N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331 N5047AAeroslat4 LLC · Lewes, DEBuilt 1955 · S/N 28047 N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340 N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347 N504JRitter Michael W · Cumberland, MDBuilt 1974 · S/N 15076142 N50502Behnke Randall · Manitowoc, WIS/N 15069351 N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352 N5050ACampbell Barry A · Rogersville, TNBuilt 1955 · S/N 28050 N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376 N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377 N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378 N50535Harrell Lewis H · Pontotoc, MSS/N 15069380 N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382 N5053AKing David · Frisco, COBuilt 1955 · S/N 28053 N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384 N50544Kidd Ronnie E · Ramseur, NCS/N 15069386 N5054AGrimmonpre Gary · Huntley, ILBuilt 1955 · S/N 28054 N50550Registered aircraftS/N 15069391 N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392 N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396 N5055AN5055a LLC · Clayton, GABuilt 1955 · S/N 28055 N5056RMiller Charles A · Walla Walla, WAS/N 6-3080 N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405 N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408 N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409 N5057ASoar Above Flight Solutions LLC · Englewood, TNBuilt 1955 · S/N 28057 N5058Bsa 12 LLC · Farmington Hills, MIBuilt 2008 · S/N CC11-00073 N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411 N50581Pritchett Otis R · Avery, TXS/N 15069412 N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414 N5058ABeiter John A · Cle Elum, WABuilt 1955 · S/N 28058 N5058HTyrl Ryan J · Stillwater, OKS/N 11-957 N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423 N5059ASmith Rickey A · Divernon, ILS/N 28059 N5059HChase Joshua R · Princeton, MNBuilt 1949 · S/N 11958 N505CACarver David N · Sanger, CABuilt 1975 · S/N 15076821 N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911 N505JJAero Davis LLC · Camden, DEBuilt 1958 · S/N 46086

Back to AD 94-05-05 R1