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.

N961DACondair Flyers Inc · Latham, NYBuilt 1996 · S/N 2843034 N961GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881226 N961TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881961 N961WLoma Aviation LLC · San Diego, CABuilt 1966 · S/N 28-3811 N961WGChandler Air Service Inc · Chandler, AZBuilt 2000 · S/N 2843376 N9621KHinson Bradford L · Thomasville, GABuilt 1976 · S/N 32R-7680232 N9622CN9622c LLC · Clintondale, NYS/N 28-7816504 N9622JAlpha Bravo Aviation LLC · Queen Creek, AZBuilt 1966 · S/N 28-3778 N9622WKahn Aaron D · Alexandria, VABuilt 1967 · S/N 28-23079 N9623JVirginia Street Partnership · Farmville, VABuilt 1966 · S/N 28-3779 N9623WLiu Kevin R · Alhambra, CABuilt 1967 · S/N 28-22988 N9624JTideline Aviation LLC · Wilmington, NCBuilt 1966 · S/N 28-3780 N9624WJanak Jeffrey J · Corpus Christi, TXBuilt 1967 · S/N 28-23080 N9626CExecutive Flight Training & Services LLC · Sanford, NCBuilt 1978 · S/N 28-7816506 N9626JCharles James Blake · Stinnett, TXBuilt 1966 · S/N 28-3782 N9627JTucker Aviation LLC · Hollister, MOBuilt 1966 · S/N 28-3783 N9628JMarshall Air LLC · Albuquerque, NMS/N 28-3785 N9628KTriple Chin LLC · Bloomington, MNBuilt 1976 · S/N 28-7690266 N9629CFly Gateway Aviation Institute · New Castle, DEBuilt 1978 · S/N 28-7890430 N9629JBrown Korey Fetty · Macungie, PABuilt 1966 · S/N 28-3786 N9629KN9629k LLC · Provo, UTBuilt 1976 · S/N 28-7690267 N9629WRobbins Clyde · Golden, MSBuilt 1967 · S/N 28-23086 N962FMarshall Steven A · Blacksburg, VABuilt 1998 · S/N 3257067 N962GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881227 N962MSMt San Antonio College · Walnut, CABuilt 1976 · S/N 28R-7635459 N962WGChandler Air Services Inc · Chandler, AZBuilt 2000 · S/N 2843378 N962WWMindlin Frank August · New Haven, CTBuilt 2000 · S/N 2844022 N9630WNull Robert D · Lake Charles, LABuilt 1967 · S/N 28-23087 N9631CThompson Joseph D · Alliance, NEBuilt 1978 · S/N 28-7890431 N9631JMckibben Andrew D · Gilmanton Iw, NHBuilt 1966 · S/N 28-3788 N9632JAirbrain Aviation Inc · Snellville, GABuilt 1966 · S/N 28-3789 N9633WFladager Enterprises Inc · Peerless, MTBuilt 1967 · S/N 28-23090 N9634K137 Lynwood LLC · Elmira Heights, NYS/N 28R-7635251 N9634WShinar Philip C · California City, CABuilt 1967 · S/N 28-23091 N9635KN9635k LLC · San Luis Obispo, CAS/N 28-7610105 N9635WGordon David · Long Branch, NJBuilt 1967 · S/N 28-23092 N9636JPorter Julia N · Pflugerville, TXBuilt 1966 · S/N 28-3833 N9636KVanderwerf Stan L · Colorado Springs, COBuilt 1976 · S/N 32R-7680234 N9637KClik Services LLC · Forestdale, MABuilt 1976 · S/N 32R-7680235 N9638CJones Francis P Jr · Newport, ARBuilt 1978 · S/N 28-7816507 N9638JPrince Jennifer R · Farr West, UTBuilt 1967 · S/N 28-3867 N9639CNichols Brian J · Mount Hope, WIBuilt 1978 · S/N 28-7816508 N9639WUlmer Daniel J · Menno, SDBuilt 1967 · S/N 28-23097 N963ABPiper Aircraft Inc · Vero Beach, FLS/N 28010090 N963MRAerospace Trust Management LLC · Wilmington, DEBuilt 1967 · S/N 28-10838 N963NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881888 N963TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881963 N963WCCavorite Aviation LLC · Lehi, UTBuilt 2000 · S/N 2843381 N963WWCash Management Consulting LLC · Granite Springs, NYBuilt 2000 · S/N 2844023 N9641JRegistration Pending · Fresno, CARegistration pendingS/N 28-3865

Back to AD 87-08-08 R3