Registered aircraft · 27

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

N10RTBarbers Point Flight School LLC · Kapolei, HIS/N 285 N1169Downes Pamela · Chino Hills, CABuilt 1956 · S/N 390 N1187DCordero Miguel · Hollywood, FLS/N 680-626-252 N124JPCommemorative Air Force · Dallas, TXBuilt 1956 · S/N 312 N2665BSteria Kermit J · Monahans, TXBuilt 1956 · S/N 374 N2732BWolff Martin · Houston, TXBuilt 1955 · S/N 232 N2750BRodrigues Steven W · Manteca, CABuilt 1956 · S/N 410 N2755LMerxbauer Terry E · La Pine, ORBuilt 1955 · S/N 680-255 N2782BAbbing Frits G H · Crescent City, FLBuilt 1957 · S/N 559 N2788BK&L Agri Farms Inc · Adams, NEBuilt 1957 · S/N 560 N30UAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1955 · S/N 247 N3341Sale Reported · La Plata, NMSale reported, pending cancellationBuilt 1956 · S/N 680-456-126 N3846CCrowder Eston W · Dade City, FLS/N 709 N424RKTerry Ryan · White Lake, MIBuilt 1955 · S/N 238 N4618ESale Reported · El Paso, TXSale reportedBuilt 1959 · S/N 737 N561KEMaglaughlin Ronald D · Udall, KSS/N 680-322-16 N56FRWoods Mark T · Fernandina Beach, FLBuilt 1955 · S/N 260 N58GSzarek Evelyn Personal Representative · Fairbanks, AKBuilt 1957 · S/N 680-519-189 N6217DSmithey Larry M · Wake Forest, NCS/N 680-485-155 N6222DRobertson C A · Phoenix, AZS/N 680-490-160 N623FSMorse Edward K Jr · Wasilla, AKS/N 578 N6278DSale Reported · Oklahoma City, OKSale reportedBuilt 1957 · S/N 548216 N677JRRoach James M · West Bountiful, UTBuilt 1958 · S/N 680-647-254 N68113Gogoplex LLC · Wilmington, DEBuilt 1956 · S/N 680-316-11 N6819QWalker Gilbert R · Brentwood, TNBuilt 1957 · S/N 680-488-158 N6883SWebb Ronald G · Dickson, TNBuilt 1956 · S/N 680-407-83 N70DMartin Ernest · Sandpoint, IDS/N 268

Back to AD 57-15-01