Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4604XDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2012 · S/N 91252 N46050Sentinel Services Group LLC · Brooksville, FLS/N 28-7325267 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N4605JNichols James M · Duanesburg, NYS/N 28R-30485 N4605RFive Eagles Group LLC · Pompano Beach, FLBuilt 1966 · S/N 28-21353 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N4606JKantor Robert James · Rancho S Margarita, CABuilt 1968 · S/N 28R-30486 N4606RAiken Pilot Training LLC · Johnston, SCBuilt 1965 · S/N 28-21354 N4606WCornwell Stephen E · Beaumont, TXBuilt 1976 · S/N 13096 N4606YAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1967 · S/N 25-4303 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N4607JHodgen Robert T III · Lexington, KYBuilt 1968 · S/N 28R-30487 N4607RBayside Aviators LLC · Union City, CAS/N 28-21356 N4607WWalmer David H · Tualatin, ORBuilt 1976 · S/N 13097 N46085Davenport Jimmy J · Hayesville, NCBuilt 1974 · S/N 17264175 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034 N4608WWalden Brian S · Mount Vernon, OHBuilt 1976 · S/N 13098 N46091Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17264176 N4609QN4609q LLC · Opa-Locka, FLBuilt 1973 · S/N 17261724 N4609SN4609s LLC · Verona, WIBuilt 1979 · S/N R18201355 N4609WBoling Kyle C · Oak Hill, FLS/N 13099 N460AAAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 2881528 N460ACArizona Skies Aviation LLC · Scottsdale, AZBuilt 2000 · S/N 440-2000 N460FLHillenbrand Sean P · Westminster, CABuilt 1971 · S/N 28-7125257 N460JBLipscomb Richard L · Bowie, TXBuilt 2001 · S/N 690-320-434 N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77 N460LZChapman Daniel W · Soldotna, AKBuilt 1983 · S/N 460 N460NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881655 N460PHRicter Edward T · Fairbanks, AKBuilt 1988 · S/N 7493C N460RWicklund Gerald G · Liberty, MOS/N 18267786 N460TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881860 N460UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020163 N460XSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816581 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042 N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046 N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047 N4610DWolf Gary J · College Grove, TNBuilt 1997 · S/N 22062 N4610QBlaire William C · Rch Palos Vrd, CABuilt 1973 · S/N 17261725 N4610RClick Dennis R · Seattle, WABuilt 1965 · S/N 28-21359 N4610YPanama City Cycles Inc · Panama City, FLBuilt 1971 · S/N 18-8940 N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049 N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051 N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052 N4611REdwards Ruben W · Mesa, AZBuilt 1966 · S/N 28-21360 N4611WPhillips James E · Mammoth Lakes, CAS/N 13101 N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054 N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056

Back to AD 87-10-06 R1