Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277 N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049 N8301CBeach Aero LLC · Virginia Beach, VABuilt 1975 · S/N 28R-7635144 N8302YArnold Roger R · Jonesville, LAS/N 30-1441 N8303UInternational Air Service Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 348170048 N8303XDream Big Aero Corp · Wilmington, DEBuilt 1980 · S/N 34-8170049 N8304YLusk Thomas L · Centennial, COS/N 30-1443 N8306LStar Oil & Gas Co · Hobbs, NMBuilt 1980 · S/N 34-8170051 N8306NGularte Gavin · Berkeley, CAS/N 34-8170052 N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448 N830CM111 Aviation LLC · Lewes, DES/N 34-7350275 N830PCSprowl Brian M · Millville, NJS/N 28R-7335055 N830YDPrestige Aviation Group LLC · Orlando, FLBuilt 1976 · S/N 34-7770068 N8310PPremiere Aviation Inc · Concord, CABuilt 1963 · S/N 24-3560 N8311CProficient Computing Solutions Corp · Fernandina Beach, FLBuilt 1975 · S/N 32R-7680092 N8311PDuckett Kristofer · Fairfield, CAS/N 24-3561 N8311YAj Air LLC · Cape Girardeau, MOBuilt 1967 · S/N 30-1450 N8313PSpencer Cory · Mobile, ALBuilt 1963 · S/N 24-3563 N8313YUnusual Attitudes LLC · Bates City, MOBuilt 1967 · S/N 30-1452 N8315ABrightwell Albert Jr · Seneca, SCBuilt 1980 · S/N 34-8170072 N8315PSquawk Wv LLC · Morgantown, WVBuilt 1963 · S/N 24-3565 N8315YGolden Compass Aviation LLC · Wilmington, DEBuilt 1967 · S/N 30-1455 N8316PHolbrook James K · West Liberty, KYBuilt 1963 · S/N 24-3567 N8316YSchubnell Ryan A · Avondale Estates, GAS/N 30-1456 N8318PPlane Old Memes LLC · Seminole, FLBuilt 1964 · S/N 24-3569 N831JRRegistration Pending · High Springs, FLRegistration pendingBuilt 1959 · S/N 24-585 N8320PCallicrate Michael P · Saint Francis, KSBuilt 1963 · S/N 24-3571 N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460 N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147 N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463 N8324CSingh Javier · Atlanta, GABuilt 1976 · S/N 34-7670126 N8324PCirrus Air LLC · Eden, NCBuilt 1963 · S/N 24-3575 N8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465 N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468 N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469 N8328PSale Reported · Lewes, DESale reportedS/N 24-3581 N8328VQuick Gas Aviation LLC · Thomasville, GABuilt 1981 · S/N 34-8170084 N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470 N8329YHarbock Inc · Wilmington, DEBuilt 1967 · S/N 30-1471 N8331PBurbanks Travis R · Tarzana, CABuilt 1963 · S/N 24-3584 N8331YFeit Paul · Osprey, FLS/N 30-1476 N8332CKyro Kevin D · Lakeville, MNS/N 28R-7635148 N8332PGray James Gary · Simpsonville, SCBuilt 1963 · S/N 24-3585 N8333PAllred Klein Enterprise LLC · San Diego, CABuilt 1963 · S/N 24-3586 N8334CR & D Aviaton LLC DBA · Atkinson, NEBuilt 1976 · S/N 34-7670127 N8336PWyatt Gary D · Sun City West, AZS/N 24-3590 N8336YPatterson Thomas A · Minerva, OHBuilt 1967 · S/N 30-1481 N8337CStahel Zazell L · Kiana, AKBuilt 1976 · S/N 32R-7680101 N8337YBorden William · Commerce Township, MIBuilt 1967 · S/N 30-1483 N8338PHerndon Properties LLC · Walterboro, SCS/N 24-3593

Back to AD 97-01-01 R1