Skip to content

Registered aircraft · 54,015

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N6406BWojtacha Jacob M · Wasilla, AKBuilt 1956 · S/N 29606 N6406EOwczarek Przemyslaw J · Hampton Bays, NYBuilt 1959 · S/N 46506 N6406KWandell Daniel J · Murfreesboro, TNBuilt 1975 · S/N 15077687 N6406XIronsides Custom Grinding Inc · Waitsburg, WAS/N 50906 N64074Green Norman D · Lake City, FLBuilt 1975 · S/N 17265000 N64079Portneuf Holdings LLC · Chubbuck, IDBuilt 1981 · S/N 17275516 N6407BMclean Diane A · Weirsdale, FLBuilt 1956 · S/N 29607 N6407DWalo Enterprises LLC · Aurora, COBuilt 1979 · S/N 17272790 N6407EN6407e LLC · Hanover, MDBuilt 1959 · S/N 46507 N6407VWard Matthew A · Fort Worth, TXBuilt 1980 · S/N 172RG0669 N64081Burrows Donna M Trustee · Grain Valley, MOBuilt 1975 · S/N 17265004 N64082Mcdonald Douglas W Sr · Cornelia, GABuilt 1975 · S/N 17265005 N64087California Airways LLC · Hayward, CABuilt 1981 · S/N 17275519 N6408EMorgan Lloyd J · Memphis, MOBuilt 1959 · S/N 46508 N6408GWebb Joe R · Union, WABuilt 1979 · S/N 17273594 N6408KShowah Michael F · Scottsdale, AZS/N 15077688 N6408NBorders Nowell W · Edinburg, TXBuilt 1978 · S/N 21062984 N64091Fahnestock John L · Melbourne, FLS/N 17266497 N64092Falcon William D · Elkhorn, WIS/N 17265012 N64095Righthand 2004 LLC · Charlotte, NCBuilt 1975 · S/N 17265015 N64096Bissey Roy H II Trustee · Big Horn, WYBuilt 1975 · S/N 17265016 N64099Tullio John P · Edgewood, TXBuilt 1977 · S/N 18052870 N6409DMontgomery Aviation LLC · San Diego, CABuilt 1979 · S/N 17272791WP N6409EChehalis Skies Aircraft LLC · Chehalis, WABuilt 1959 · S/N 46509 N6409FStatusair LLC · Mount Arlington, NJBuilt 1966 · S/N 15063009 N6409KBredvold Daniel M · Mendota Heights, MNS/N 17274098 N6409MCendejas Agustin · Chino, CABuilt 1980 · S/N 15284713 N6409WBreedlove Joe · Skiatook, OKBuilt 1981 · S/N P21000770 N6409XValdes Omar F · Huntington Park, CAS/N 15068652 N6409YChino Aviation Inc · Chino, CABuilt 1981 · S/N 21064369 N640MGAviate LLC · Green Bay, WIBuilt 1975 · S/N 17265248 N640SLKoonce Gary L · Midland, TXBuilt 1965 · S/N 18256483 N64103Parra Raymond · Miami, FLS/N 17275522 N64106Long Leslie Bruce Jr · New Durham, NHBuilt 1981 · S/N 17275523 N64107Cmbb Enterprises LLC · Plainview, TXBuilt 1975 · S/N 17265023 N64108Wiater Mark S · Crete, ILBuilt 1975 · S/N 17265024 N64109Bickford Shawn A Trustee · Big Lake, AKBuilt 1977 · S/N 18052871 N6410ANichols John W · Post Falls, IDBuilt 1956 · S/N 33210 N6410EKelaita Dean M · Mokelumne Hill, CABuilt 1959 · S/N 46510 N6410NAerial Services Inc · Cedar Falls, IABuilt 1978 · S/N 21062986 N6410SSaunders Aviation LLC · Roanoke, TXBuilt 1967 · S/N 15067210 N6410VEckerle Christopher K · San Bruno, CABuilt 1980 · S/N 172RG0672 N64111Jasper Co Airport Authority · Rensselaer, INBuilt 1975 · S/N 17265027 N64114Mccully Aviation LLC · Payson, AZBuilt 1975 · S/N 17265030 N64119Augustus Aircraft LLC · Whitefish, MTBuilt 1975 · S/N 17265034 N6411GL-Bird LLC · Hood River, ORBuilt 1970 · S/N 15071911 N6411VSouth Air Aviation LLC · Miami, FLBuilt 1980 · S/N 172RG0673 N64120Ham Derek · Independence, ORS/N 17265035 N64129Atlanta Aviation Academy Inc · Lawrenceville, GAS/N 17275525 N6412BFlight Expo Inc · Princeton, MNS/N 29612

Back to AD 87-20-03 R2