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.

N7820ZBuckley Joseph L · Gulfport, MSBuilt 1963 · S/N 15059920 N78215Alvarado Eduardo · Fayetteville, TXBuilt 1968 · S/N 17257530 N78219Testa Christopher · Kennesaw, GAFirst renewal noticeBuilt 1968 · S/N 17257532 N7821AKw Air LLC · Darlington, INS/N 32718 N7821FKoch Leasing LLC · Campbellsville, KYBuilt 1966 · S/N 15063921 N7821KFlood John · Bozeman, MTBuilt 1976 · S/N 18052755 N7821TCameron Michael Shelley · Reno, NVBuilt 1960 · S/N 47421 N78221Waldrop Floyd D · Robinson, ILBuilt 1968 · S/N 17257534 N78228Lanning Keith L · Everton, ARBuilt 1968 · S/N 17257537 N7822KStahl Richard J · Gainesville, TXBuilt 1976 · S/N 18052756 N7822UKelly John K · Summerfield, NCS/N 17251822 N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540 N7823FJackson Larry T · Maplesville, ALS/N 15063923 N7823GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259523 N7823ZFrost Read Ferguson · Burlington, VTBuilt 1963 · S/N 15059923 N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541 N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543 N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545 N7824XClampitt Kenton V · Eckert, COBuilt 1960 · S/N 17248324 N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546 N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547 N7825UVan Dyke Randall R · Spencer, IABuilt 1964 · S/N 17251825 N7825ZBalk Martin L · Warren, NJBuilt 1963 · S/N 15059925 N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549 N7826GSeabold Todd J · Craig, COBuilt 1974 · S/N 18263329 N7826UDenton Aeroworx LLC · Tucson, AZBuilt 1964 · S/N 17251826 N7827GFlying Falkor LLC · Bellevue, WAS/N 15074732 N7827KTvc Fliers LLC · Traverse City, MIBuilt 1976 · S/N 18052761 N7827TToler Gary P · San Clemente, CAS/N 47427 N7827UCook Loretta · Bel Air, MDBuilt 1964 · S/N 17251827 N7827XBarrows Carl A · Lisle, NYBuilt 1961 · S/N 17248327 N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554 N7828FTaylor Andrew G · Lexington, KYBuilt 1966 · S/N 15063928 N7828KMader James Jay · Lino Lakes, MNBuilt 1976 · S/N 18052763 N7828TBunde Konstantine E · Goldendale, WABuilt 1960 · S/N 47428 N7828UDroz Chris G · Jamul, CAS/N 17251828 N7828XAero Smart LLC · Preston, IDBuilt 1961 · S/N 17248328 N7828ZShelburne Airport Inc · Shelburne, VTS/N 15059928 N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556 N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558 N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529 N7829TDampier William · Greenwood, INBuilt 1960 · S/N 47429 N7829XObservation Corp · Newark, CABuilt 1961 · S/N 17248329 N7829ZMclaughlin Dustin T · Abilene, KSBuilt 1963 · S/N 15059929 N782CB182q LLC · Anthem, AZBuilt 1979 · S/N 18267192 N782DGLasalle Investments LLC · Tucson, AZBuilt 1975 · S/N 18263557 N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667 N782RGL-Bird LLC · Hood River, ORBuilt 1978 · S/N R18200194 N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341 N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559

Back to AD 87-20-03 R2