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.

N8857CValkenburg Toby · Anchorage, AKBuilt 1953 · S/N 18-2914 N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028 N8858CLebron Renard Jr · Gulfport, MSBuilt 1953 · S/N 18-2922 N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030 N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032 N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026 N8863CClearsky II LLC · Tyler Hill, PABuilt 1953 · S/N 22-1494 N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037 N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038 N8865CMayo Jesse J · Fairbanks, AKS/N 20-1034 N8866CEckels Shaun R · Pickerington, OHBuilt 1953 · S/N 20-1031 N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867 N8868EArizona Soaring Inc · Maricopa, AZBuilt 2022 · S/N LA-260-21063 N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944 N8870CRegistration Pending · Canal Fulton, OHRegistration pendingBuilt 1953 · S/N 22-1479 N8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044 N8871CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N 22-1484 N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045 N8872CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1024 N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046 N8873CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1023 N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047 N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049 N8877CBall Fred · College Place, WABuilt 1953 · S/N 20-1025 N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051 N8878CJones Brian K · Scituate, MABuilt 1953 · S/N 22-1488 N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052 N8879CMadden John J Jr Co-Trustee · Frostproof, FLBuilt 1953 · S/N 22-1489 N8879YWelstad Blaine L · Newburg, NDBuilt 1973 · S/N 18-7409027 N887WCGalindo Don R Jr · Walnut Grove, CABuilt 1952 · S/N 22-887 N8881CMcintosh Ronald J · Walker, WVBuilt 1953 · S/N 22-1462 N8881DOlder Dan · Bellingham, WABuilt 1958 · S/N 18-6351 N8882DBanta Joshua Darracott · Dallas, GAS/N 18-6352 N8883CBall Travis W · Aleknagik, AKBuilt 1953 · S/N 22-1465 N8884CHartman Linda C · Malin, ORBuilt 1953 · S/N 22-1468 N8884DJ C Aero LLC · Yelm, WABuilt 1958 · S/N 6354 N8887CHorinek Troy C · Goodland, KSS/N 22-1470 N8888YPriebe Rodney M · Wasilla, AKBuilt 1973 · S/N 18-7409028 N8889DWateractive43 LLC · Auburn, CAS/N 18-6358 N8891CSchroeder Thomas M · Georgetown, TXBuilt 1953 · S/N 22-1478 N8894CBrent Thomas P · Walnut, MSBuilt 1953 · S/N 22-1475 N8894DPyle Jarod H · Wasilla, AKBuilt 1958 · S/N 18-6368 N8895DMeggers Roger D · Baker, MTBuilt 1958 · S/N 18-6369 N8896DGidzinski David A · Weirsdale, FLBuilt 1958 · S/N 18-6370 N8898DWelty Donald Robert Jr · Glennallen, AKBuilt 1958 · S/N 18-6374 N8899YSture Joel M · Anchorage, AKBuilt 1974 · S/N 18-7409031 N889TJvs LLC · Santa Rosa, CABuilt 1957 · S/N 18-5540 N88AKState Of Alaska · Anchorage, AKBuilt 1965 · S/N 18-8311 N88ALChristenson Lloyd Gregory · Side Lake, MNBuilt 1946 · S/N 12-971 N88DPPiper David B · Lake Placid, FLBuilt 2021 · S/N JA1906130

Back to AD 99-01-05 R1