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.

N5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 477 N5690UPena Flight Partners LLC · Oakland, CABuilt 1970 · S/N 28-26488 N56918Virgil Osvaido J · Glendale, AZBuilt 1973 · S/N 28-7415037 N5691MBrowning Robert F · Washington, DCBuilt 1980 · S/N 485-2 N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763 N5692QOpen Air Aviation LLC · Colorado Springs, COBuilt 1965 · S/N 702 N5692VI N K M & Associates Lllp · Columbia, MOBuilt 1977 · S/N 32R-7780362 N5692WFollmer Harvey C III · Trout Run, PABuilt 1963 · S/N 28-1045 N5692YSilverado Sales Inc · Orem, UTBuilt 1980 · S/N 494-2 N56934Low Allen R · San Francisco, CABuilt 1973 · S/N 32-7400011 N56937Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7410031 N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766 N5693QKaufman Ben · Liberty, UTBuilt 1965 · S/N 3045 N5693SChupp David · Abbeville, SCBuilt 1966 · S/N MA-94 N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813 N56942Oracle Aviation LLC · Omaha, NEBuilt 1973 · S/N 28-7410032 N56943Mcdowell David M · El Cajon, CABuilt 1973 · S/N 28-7425066 N56947Wings Of Hope · Chesterfield, MOBuilt 1973 · S/N 28-7415027 N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2 N5694HTischer William D · Shoreview, MNBuilt 1965 · S/N TD-243 N5694UPlencner Robert E · Round Lake Beach, ILBuilt 1969 · S/N 28-26491 N5694WLange James R · Tempe, AZBuilt 1963 · S/N 28-1060 N56950Bodily Kent A · Washington, UTBuilt 1973 · S/N 28-7405038 N56957Payne Glenn · Oregon, MOBuilt 1973 · S/N 28-7425070 N56958Jackson Michael L · Nixa, MOFirst renewal noticeS/N 28-7425071 N5695QBabb Douglas L · Telford, PABuilt 1965 · S/N 3046 N5695W95whiskey LLC · Georgetown, MABuilt 1963 · S/N 28-1070 N56964Lafollette Larry E · Strafford, MOBuilt 1973 · S/N 28-7405052 N56965Brazos River Aviation LLC · Plainview, TXBuilt 1973 · S/N 28-7410036 N56966West David A · Astoria, ORBuilt 1973 · S/N 28-7425067 N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2 N5696QTrilogy Alliance Group LLC · Kearney, NEBuilt 1965 · S/N 762 N5696WGiglio Tom J · South Boston, VABuilt 1963 · S/N 28-1072 N56970Simoneau Todd · Sandown, NHS/N 28-7405039 N56972Eby Aviation LLC · Duluth, GABuilt 1973 · S/N 28R-7435067 N56973Baja Flyers Inc · San Diego, CABuilt 1973 · S/N 28-7410039 N56976Tate Bird L Jr · Hammond, NYBuilt 1973 · S/N 28-7425075 N56977Evans Holland L · Danielsville, GABuilt 1973 · S/N 28-7425076 N56978Brindley James G · Collinsville, ALBuilt 1973 · S/N 28-7425077 N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922 N5697QReed Timothy W · Terrell, TXBuilt 1965 · S/N 815 N56986Loya Armando · Whittier, CABuilt 1973 · S/N 28-7425079 N56987Ravotti Air LLC · Leechburg, PABuilt 1973 · S/N 28-7415032 N56988Hillerman Paul J · Vinita, OKBuilt 1973 · S/N 28-7415033 N56989Kenny Zachary D · Herndon, VABuilt 1973 · S/N 28-7405040 N5698QCaughell David S · Bartlesville, OKBuilt 1965 · S/N 705 N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102 N5698UNorby David S · Gooding, IDS/N 28-26495 N5698WBurkett Aviation LLC · Hampstead, NCBuilt 1963 · S/N 28-1094 N56991Schneider Stephen C · Denton, TXBuilt 1973 · S/N 28R-7435070

Back to AD 87-10-06 R1