Skip to content

Registered aircraft · 22,416

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

N7624JBriggano LLC · Mount Pleasant, SCBuilt 1969 · S/N 28R-31102 N7624WHartley Douglas R · Florence, ALBuilt 1964 · S/N 28-1589 N7625FHarbaugh Steven J · Riverside, CAS/N 28-7725091 N7625JHuebscher Attila · Flemington, NJBuilt 1968 · S/N 28R-31020 N7625WWings Up LLC · Manteno, ILBuilt 1965 · S/N 28-2914 N7626FJamestown Jet Center Inc · Jamestown, NDBuilt 1976 · S/N 28-7715214 N7626WStiles Kenneth R · Ozawkie, KSBuilt 1964 · S/N 28-1591 N7627DVanhouse Daniel W · Topeka, KSBuilt 1969 · S/N 28R-35055 N7627FLo Co Holdings LLC · Loudon, TNS/N 28-7715215 N7629FEagle Archer Pilots LLC · Indianapolis, INS/N 28-7790198 N7629JWatson Tony A · Rydal, GABuilt 1969 · S/N 28R-31024 N7629WMah Michael · Pittsfield, MAS/N 28-1596 N762JMPridgen Michael E · Odenton, MDBuilt 1978 · S/N 32R-7887128 N762MBlaisdell Frederick C · Anderson, CABuilt 1978 · S/N 28R-7931015 N762NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010019 N762SSShetter Steven P · Chambersburg, PABuilt 1978 · S/N 28-7816537 N7631FMatthew E Richards · Southaven, MSS/N 28-7725093 N7631WDyer Troy · Wolcottville, INBuilt 1964 · S/N 28-1599 N7632FFlymart Inc · Hastings, FLS/N 28-7715216 N7633FState Line Gas Service Inc · Mc Knightstown, PAS/N 28-7715217 N7633WBeery Beau · Brockway, MTBuilt 1964 · S/N 28-1602 N7634CGarrison John · Temple, TXBuilt 1975 · S/N 28-7625078 N7634JSullivan Wade M · Mukilteo, WABuilt 1968 · S/N 28R-31030 N7635JBecker Riley · Transylvania, LABuilt 1969 · S/N 28R-31032 N7635WDependable Aviation LLC · Cartersville, GABuilt 1964 · S/N 28-1604 N7637F37 Foxtrot LLC · Mesa, AZBuilt 1976 · S/N 28-7790200 N7637JMartin Kevin H · Selbyville, DEBuilt 1968 · S/N 28R-31036 N7638FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 32-7740014 N7638JSeward Charles Ryan · Nashville, INBuilt 1968 · S/N 28R-31037 N7639FArrona David M · San Luis Obispo, CABuilt 1976 · S/N 32R-7780068 N7639JCampbell Ronald David · Etna, WYBuilt 1968 · S/N 28R-31038 N7639WWiese Andrew T · Gibsonburg, OHBuilt 1964 · S/N 28-1609 N7640WHine Timothy R · Rogersville, ALBuilt 1964 · S/N 28-1612 N7641JFrazier Michael K · Abbeville, GABuilt 1968 · S/N 28R-31041 N7642JUniversal Technical Institute Inc · Coppell, TXBuilt 1968 · S/N 28R-31042 N7643CRials Tommy G · Crystal Springs, MSBuilt 1975 · S/N 28-7615057 N7643FMaple43f LLC · Hubbardston, MABuilt 1976 · S/N 28-7715222 N7643WBlasen Matthew C · La Center, WABuilt 1964 · S/N 28-1616 N7644FBel Holdings LLC · Albert Lea, MNBuilt 1976 · S/N 28-7790201 N7644WCatania Robert S · Mooresville, INBuilt 1964 · S/N 28-1617 N7645FSagittarius Fox Aviation LLC · San Francisco, CABuilt 1976 · S/N 28-7790202 N7645JArrow 8 LLC · Chicago, ILBuilt 1969 · S/N 28R-31045 N7645WGold Rush Air LLC · Anchorage, AKBuilt 1964 · S/N 28-1620 N7646FShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 28-7790204 N7646JRavotti Air LLC · Leechburg, PABuilt 1968 · S/N 28R-31046 N7647WBeaulaurier Robert N · Walla Walla, WABuilt 1964 · S/N 28-1623 N7649FPadilla Jeffrey S · Lehigh Acres, FLS/N 32R-7780072 N7649WPatterson Cameron L · Stafford, VAS/N 28-1625 N764CCYale Companies LLC DBA Hot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 2881918 N764JBLance Aviation Inc · Lakeland, FLBuilt 1976 · S/N 32R-7680506

Back to AD 87-08-08 R3