Skip to content

Registered aircraft · 2,553

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

N6971LCw Equipment Rentals Inc · Biggs, CABuilt 1966 · S/N 310K0071 N69723O'Brien John P · Centerville, OHBuilt 1973 · S/N 310Q0942 N69728Sharff Steven T · Georgetown, DEBuilt 1973 · S/N 310Q0945 N69729Eastern Florida State College · Cocoa, FLBuilt 1973 · S/N 310Q0946 N69743Howard Richard J · Sioux Falls, SDS/N 310Q0955 N69744Registered aircraftBuilt 1973 · S/N 310Q0956 N69754Elevated 7 LLC · Kalispell, MTBuilt 1973 · S/N 310Q0961 N69797N69797 LLC · Denver, COBuilt 1973 · S/N 310Q0983 N6979LIntravaia Anthony J · Saint Louis, MOS/N 310K0079 N6979TDavis Richard L Jr · West Union, OHS/N 39279 N6980TAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 39280 N69831Epic Aviation Services LLC · Kemah, TXBuilt 1973 · S/N 310Q1005 N69842D2 Aviation LLC · League City, TXBuilt 1974 · S/N 310Q1012 N69846Billingsley Arthur B · Green Cove Springs, FLBuilt 1974 · S/N 310Q1016 N69848Onaero Inc · Santa Monica, CABuilt 1974 · S/N 310Q1017 N6986THenley Mark L · Greenwood, MSBuilt 1960 · S/N 39286 N6988LCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N 310K0088 N6988TPlecity John G Jr · Danbury, CTBuilt 1960 · S/N 39288 N69937Hellix LLC · Charlotte, NCBuilt 1974 · S/N 310Q1028 N69938Stapleton John Blase · Gulf Shores, ALBuilt 1974 · S/N 310Q1029 N69942Columbus State Community College · Columbus, OHBuilt 1974 · S/N 310Q1033 N6994LVance Austin Leasing Enterprises Inc · Blytheville, ARFirst renewal noticeBuilt 1966 · S/N 310K0094 N69951Cosper Jared L · Austin, TXBuilt 1974 · S/N 310Q1042 N6995LBaker James W · Wildwood, MOBuilt 1966 · S/N 310K0095 N6995TJohnson William · Dalton, GABuilt 1960 · S/N 39295 N6997LMcnutt Chris L · Anna, TXBuilt 1966 · S/N 310K0097 N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055 N699JSJustin Seth Drach Pa · Jacksonville, FLBuilt 1975 · S/N 421B0941 N699WSGivens Byron Keith Jr · Warner Robins, GAS/N 310Q1050 N69HBRowe Michael J · Crest Hill, ILBuilt 1974 · S/N 310Q1024 N69PBAerocraft Papa Bravo LLC · Hallandale, FLS/N 402B-1248 N69PGBaird Mark · Fort Jones, CABuilt 1972 · S/N 340-0062 N69RHWheels Down Air LLC · Toledo, OHS/N 401A-0122 N69SAColvin Clu A DBA · Big Cabin, OKS/N 39160 N69SKSale Reported · Lancaster, TXSale reported, pending cancellationS/N 35848 N69WBLawrence Joseph · Cushman, ARS/N 310L-0199 N6KHRegistration Pending · Indian River, MIRegistration pendingS/N 310R0841 N6LHTrico One-Ten Inc · Azle, TXFirst renewal noticeBuilt 1972 · S/N 421B0227 N6MKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 340-0322 N6MMLay Lawrence W · Douglas, KSBuilt 1957 · S/N 35604 N6PKBrest John E · Moses Lake, WABuilt 1964 · S/N 310I0021 N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751 N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625 N6WBOsborn William B III · San Antonio, TXFirst renewal noticeBuilt 1976 · S/N 310R0705 N6WMSchrader Jerome · Rocklin, CABuilt 1974 · S/N 421B0834 N7002LDatema Steven K · Susanville, CABuilt 1966 · S/N 310K0102 N7005LYonge Laurie W Jr · Ocklawaha, FLBuilt 1966 · S/N 310K0105 N7007LSkykings LLC · Little Rock, ARBuilt 1966 · S/N 310K0107 N7015LHeritage Aviation Management LLC · Headland, ALBuilt 1966 · S/N 310K0115 N7017L310 Aviation LLC · Schererville, INBuilt 1966 · S/N 310K0117

Back to AD 76-08-02 R2